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]