Alexandre Benson Smith wrote:

> inner join = join
> left outer join = left join
> right outer join = right join
> full outer join = full join
>
> the "outer" and "inner" are optional keywords, as Set said.

My mistake.

I wonder, is this by SQL standard? IIRC, Informix and MSSQL (on which I
learned SQL) don't do it like this. Unfortunately, I don't have any
MSSQL or Informix at hand now to test it.

Regards,
--
Milan Babuskov
http://fbexport.sourceforge.net