> So the next thing I tried was the anti-join (see > > http://en.wikipedia.org/wiki/Relational_algebra#Antijoin
First time I hear of this "antijoin". The example given on the Wiki page doesn't make much sense to me. Isn't is simply an OUTER JOIN where you're looking for NULL on the right-hand side? SELECT E.Name, D.DeptName FROM Employee AS E LEFT JOIN Dept AS D ON E.DeptName = D.DeptName WHERE D.DeptName IS NULL -- Michael Ludwig
