Matt,
On most platforms, you would generally do a sub select of the form
select playerid
from players p
where not exists
(
select *
from myplayers m
where m.player_id = p.player_id
)
However, as sub selects are only supported in mysql 4.1, you'll need to see
section 1.7.4.1 Sub queries in the manual on how to change this into a join
supported in mysql prior to 4.1
Andy
-Original Message-
From: Matt MacLeod [mailto:[EMAIL PROTECTED]
Sent: 19 September 2003 16:38
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]