Personally I find the exists/not exists statements to be more difficult to write, while the LEFT JOIN WHERE IS NULL is extremely intuitive to me. It's interesting to discover that others have the opposite view. I think there was an article just the other day on joins outperforming the use of subqueries.