Re: Outer Join with SQR

[cshelton <cshelton@INDIANA.EDU>]

David,

Outer join syntax is database dependent.  SQR passes the join clauses off
to the database, after performing the bind and dynamic variable
substitutions.  The syntax you describe below is correct for sybase.
However, it is not valid for oracle.

You will need to read the documentation for your database to determine the
appropriate syntax.

chris

On Thu, 18 Oct 2001, Thorburn, David, ITD wrote:

> All,
>
> I remember previously using an outer join technique with SQR where a '= *'
> or '* =' was used to indicate the outer join.
>
> Does anyone remember the exact syntax for coding the outer join where one
> wants to see all rows from TABLEB when TABLEB
> is joined with TABLEA?
>
> Is it TABLEA.field =* TABLEB.field ?
>