Re: Informix and OUTER join syntax

> Looking in the Informix manuals, I now see how they handle complex outer
> joins:
>
> SELECT *
> FROM tab1, OUTER(tab2, tab3)
> WHERE tab1.col1 = tab2.col1 AND
> tab2.col1 = tab3.col1
>
> It does the tab2, tab3 join first, then _outer_ joins to tab1.
> Interesting.

Here is another example that does a double outer join:

SELECT *
FROM tab1, OUTER(tab2, OUTER tab3)
WHERE tab1.col1 = tab2.col1 AND
tab2.col1 = tab3.col1

It does the tab2, tab3 as an _outer_ join first, then _outer_ joins to
tab1. Even more interesting.

Can someone show me this in ANSI syntax?

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026