Re: Outer join syntax

Don Murray wrote: > > Does anyone know how to write an outer join that is compatible with Sybase > SQLAnywhere and Informix. > > The following works on SQLAnywhere. > > FROM A left outer join B on ( A.x = B.x ) > > What are the optional ways to write this for Informix? Informix plans support for this newer ANSI syntax in 7.31+, for now Informix supports left outer joins but the syntax is: FROM A, OUTER B WHERE .... AND A.x = B.x ... BTW The new syntax will allow some interesting things to be done that were impossible in a single SELECT statement before, like selecting only those rows from the OUTER join result set where the subservient table had no rows (ie find where no match). Current syntax requires a sub-query or a temp table. Art S. Kagel