On Mar 24, 2013, at 4:13 PM, Simon Slavin <[email protected]> wrote:
> SELECT playerid FROM players WHERE playerid IS NOT IN (SELECT playerid FROM
> draftedplayers)
Alternatively:
select playerid
from players
where not exists
(
select 1
from draftedplayers
where draftedplayers.playerid = players.playerid
)
Or simply:
select playerid
from players
except
select playerid
from draftedplayers
That said… it seems to be odd to have a 'player' vs . 'draftedplayers' table…
looks like a typical is_a vs has_a confusion...
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
