
> Oh, my mistake, I forgot that the WHERE clause would filter out NULLs.
> Try
> SELECT * FROM t1 LEFT JOIN t2 ON (x = y) WHERE y <> 2 OR y IS NULL;

          x           y

          1           1
          3           NULL
          4           4

Andreas

Wed, 6 Sep 2000 17:02:01 +0200 
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: AW: A fine point about OUTER JOIN semantics 