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 (
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?