I have read various articles about outer joins with informix and that the following format should be used:
SELECT blah FROM table1, OUTER table2 WHERE table1.key=table2.foreign_key.
Yet, ANSI standard SQL lets you use the following syntax:
SELECT blah from table1 LEFT OUTER JOIN table2 ON
table1.key=table2.foreign_key
I have seen this work on a few different versions of Informix, but I have found no documentation stated what versions support the "OUTER JOIN ... ON" syntax. Can someone point me to a good resource about this?
Thanks
SELECT blah FROM table1, OUTER table2 WHERE table1.key=table2.foreign_key.
Yet, ANSI standard SQL lets you use the following syntax:
SELECT blah from table1 LEFT OUTER JOIN table2 ON
table1.key=table2.foreign_key
I have seen this work on a few different versions of Informix, but I have found no documentation stated what versions support the "OUTER JOIN ... ON" syntax. Can someone point me to a good resource about this?
Thanks