I'm testing some queries with an old version of Informix (9.2.1) and can't seem to execute even the most basic queries containing RIGHT OUTER JOIN
or FULL OUTER JOIN
. Tried several variations (RIGHT JOIN
, OUTER JOIN
or just OUTER
), but without any success. INNER JOIN
and LEFT JOIN
work fine.
Does anyone know the correct syntax for outer/right joins in older versions of Informix, or are these joins just not possible?
Best Answer
Ok, at least an outer join works just with different syntax: just using
OUTER
with a comma after the first table and aWHERE
instead of anON
.Edited to add an example from http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls679.htm