On Mar 24, 2013, at 4:13 PM, Simon Slavin <slav...@bigfraud.org> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users