Re: Outer Join with SQR

["Pattillo, Kenneth Michael" <kpattill@INDIANA.EDU>]

Other way around.

where TableA.field (+) = TableB.field  (for Oracle)

-----Original Message-----
From: Thorburn, David, ITD [mailto:DThorbur@CO.ALAMEDA.CA.US]
Sent: Thursday, October 18, 2001 12:36 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Outer Join with SQR


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 ?

Thanks,

David O. Thorburn