http://weblogs.asp.net/kbarrows/archive/2008/08/27/sql-not-in-revisited.aspxI always seem to struggle with a NOT IN clause when there are more than one column to compare.  This, of course, comes up when I am trying to get records from one set that are NOT IN another set and the comparison has to be done across multiple columnsenCommunityServer 2007 SP1 (Build: 20510.895)