Thread: AW: AW: A fine point about OUTER JOIN semantics

> 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