Re: problem selecting from one table where not in another
I will run a test in a minute and let you know.
I do have some questions regarding your query:
1. You have lp.league_id = 101 on the SELECT, which I assume assigns the value of 101 to the league_id, but on the results of the query I see league_id and further on lp.league_id = 101 with what seems a boolean. Where does this boolean come from?, also, why is it getting also results from league_id 102?
2. In order to fetch only the players for a single league I was using ".. ON ulp.league_id=102 ... " in the left joins. If the boolean result works fine for a fact then I could just add at the end of the WHERE "AND lp.league_id = 1"? would that work?
Thanks!