This is somewhat helpful for the various kinds of joins.
http://www.praetoriate.com/oracle_tips_outer_joins.htm
Still looking for complex examples.
On 8/17/06, Mike Kienenberger <[EMAIL PROTECTED]> wrote:
On 8/17/06, Andrus Adamchik <[EMAIL PROTECTED]> wrote:
> It would be nice if we could implement the translator using standard
> SQL syntax ("left outer join" instead of "(+)"), as it will work on
> most DB's including Oracle (starting from 9i), while the "(+)" syntax
> only works on Oracle (and is probably considered legacy syntax by
> Oracle too).
>
> select
> name,
> department_name
> from
> employees e
> left outer join
> departments d
> on
> e.department_id = d.department_id;
>
> It will be somewhat harder to implement, but will solve the issue
> once and for all.
Well, sure, now you tell me :-)
My Oracle Reference Book is Oracle8, so I didn't realize we had a
better choice :-)
I guess I need to see if I can find some documentation on this format.
The simple example is obvious, but what does it look like with more
tables involved, some with more outer joins and some without?
