Re: FULL JOIN syntax vs (+)

Dave Hau wrote:

> Jonathan Lewis wrote:
>
>> I think this is the correct starting point:
>>
>>
>> select {list of column}
>> from
>> a, b
>> where
>> b.id(+) = a.id -- preserve A
>> union all
>> select {list of columns}
>> from
>> b,1
>
>
> Is that a typo? Should it be "b,a" instead of "b,1"?
>
> Regards,
> Dave
>
>

Speaking for Jonathan ... Yes.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)