Re: Outer Joins in SQR

[Albert Howard <starbukk@concentric.net>]

Sandra,

Mainly as I understand it, only one table can be outer joined in Oracle.

Best tip is to avoid it by using other paragraphs to bring in associated
data whereever possible.  But if you are trying to sort or group by data in
the outer-joined table, obviously, thats not an option.

In that case, follow the other examples provided in this thread, or you
could create a temporary work table to store data, then retrieve it in the
sorted or grouped fashion.