Here we should have common/favorite/interesting SQL tricks and tips. Feel free to contribute your own.
Finding Rows in One Table with No Match in Another Table