Re: problem selecting from one table where not in another

[Israel Iglesias]

I see... because the players table does not hold the league id (only the user_players and transfer_list) then I probably should do this:

SELECT lp.*
  FROM league_player lp
  LEFT
  JOIN user_league_player ulp
    ON ulp.league_player_id = lp.league_player_id
   AND ulp.league_id = 101
  LEFT
  JOIN transfer_list tl
    ON tl.league_player_id = lp.league_player_id
   AND tl.league_id = 101
 WHERE lp.level = 1
   AND ulp.league_player_id IS NULL
   AND tl.league_player_id IS NULL;