Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"from table1, OUTER table2" vs. "from table1 LEFT OUTER table2&qu

Status
Not open for further replies.

wydok

Programmer
Jan 29, 2003
1
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top