Svein Erling wrote:

> The word INNER and OUTER are optional, so your
> LEFT JOIN is a LEFT OUTER JOIN.

AFAIK, not really. With LEFT JOIN you don't get ant records if the
"right" table doesn't match the IN clause. With LEFT OUTER JOIN, you do
get those records in "left" table that don't have matching records in
"right" table, but with all columns from "right" table as nulls.

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