At 02:28 PM 8/07/2004 +0200, you wrote:

>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.

Sorry, Milan, Set is correct. Right and left joins are *always* outer
joins, and the keyword OUTER is entirely optional.

Likewise, INNER JOIN and JOIN are identical. There is no such animal as
LEFT INNER or RIGHT INNER.

/heLen