<snip>
>I hate correlated subqueries. They are so slow.
Are you sure about that? The following query with correlated subquery will not be slower than any alternatives but is more readable
SELECT * FROM mytable mt1
WHERE NOT EXISTS (SELECT * FROM mytable WHERE id = mt1.id)
--sb--