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.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026