Re: Outer Joins in SQR

[Albert Howard <starbukk@concentric.net>]

Actually prior to the SQR II standard, all outer join rules were database
dependent.  DB2 didn't even support it.

The one-table limit did exist in older ORACLE installations, but I'm not
sure if it still does or not.  Assuming your answer is based on ORACLE, it
must not exist any more...which is a good thing.  I'll give it a shot.  Thanks.

At 06:06 PM 11/10/98 -0500, you wrote:
>Sandra/Albert,
>   You absolutely CAN outer-join multiple tables AND use them in GROUP
>BY functions... Some foresight may need to be applied but definitely
>don't avoid them... There are some rules in outer-joining you must
>adhere to... An example would be NO sub-selects against the tables that
>is outer-joined... See OUTER JOIN rules for your particular database...
>