http://weblogs.com.pk/khurram/archive/2006/06/18/4248.aspxSometimes you want to select from one list the items that exist (or don’t exist) in the second row; and for the comparison you want to use multiple rows. This is common in scenarios where you want to remove duplicate values. You might wish to write somethingenCommunityServer 2.1 SP2 (Build: 61129.2)http://weblogs.com.pk/khurram/archive/2006/06/18/4248.aspx#4254Sun, 18 Jun 2006 07:32:22 GMTa12f9144-cb49-4219-92b3-49202100e145:4254azizI think this query has a typo mistake. <br>Original : <br>select userid, username <br>from users <br>where (userid, username) not in (select userid, username from users) <br> <br>What i think : <br>select userid, username <br>from users <br>where (userid, username) not in (select userid, username from goodUsers)http://weblogs.com.pk/khurram/archive/2006/06/18/4248.aspx#4258Tue, 20 Jun 2006 12:15:41 GMTa12f9144-cb49-4219-92b3-49202100e145:4258KhurramYes, Aziz version is the one I meant!