For a current project I needed to create a table that contained a list
of exclusions that should be filtered out from another table when a
specific set of criteria were met. This is a pretty common scenario
where you have a large table of data and you want to be able to provide
the ability through a user interface for a user to filter the data
using an exclusion list.
Read the full post below:
http://www.schnieds.com/2009/03/creating-sql-exclusion-table-using-left.html
Aaron
http://www.churchofficeonline.com