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