Look up Left JOIN. This join will solve your problem. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
-->-----Original Message----- -->From: Matt MacLeod [mailto:[EMAIL PROTECTED] -->Sent: Friday, September 19, 2003 8:38 AM -->To: [EMAIL PROTECTED] -->Subject: Do I use Except? --> -->Hi, --> -->I'm building an online fantasy sports game. I want to present a list of -->players available to purchase. HOwever I need to filter out the players -->the user already has. --> -->I have a table which includes all of the players' information - name, -->position, price, etc -->I have a table which includes all of my transactions - managerid, -->playerid, dateofpurchase, dateofsale --> -->I need to select all players in the players table except those that -->occur in the transactions table which match the 'managerid'. --> -->I'm stuck! Any help would be greatfully received! --> -->Matt --> --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]