I have two tables (table1 and table2) that I want to return all records from both tables joining them on columnA, while showing all values from both tables. These two tables are not alike, so the Union query is out. Is there a Full Outer Join available in Informix?

TIA,
Jeremy

SELECT ...
FROM first_table OUTER second_table
WHERE .....

Thanks for the response. We ended up writing our own type of Full Outer join. When things slow down a little, I will try the syntax that you provided.

Jeremy