But it can make a big difference when you test id for NULL. That is how you do "MINUS" (together with LEFT JOIN). In a LEFT JOIN, it often does matter whether you put the tests on the _right_ table in the ON or in the WHERE. In the ON, rows will be excluded before you hav...
Henny Sender