Re: problem selecting from one table where not in another
yes it does... the transfer_list table hast players from all leagues so it is very hard to test it... ok so from what you're saying to exclude the players that already are on the user_league_player and transfer_list the only thing I should add to the where clause is
AND
ulp.league_player_id IS NULL
AND
tl.league_player_id IS NULL
correct?
Thank you
Subject
Written By
Posted
Re: problem selecting from one table where not in another
January 25, 2012 11:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.