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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.