Creating a SQL Exclusion Table Using LEFT JOIN
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