I suspect he wants:
SELECT users.uid
FROM users LEFT JOIN picks
ON users.uid = picks.user_id
WHERE picks.user_id IS NULL
Paul DuBois wrote:
> At 10:36 AM -0400 8/29/01, Jeremy Morano wrote:
>
>> Hi ,
>>
>> this is my query
>>
>> SELECT users.uid FROM users, picks WHERE users.uid = picks.user
At 10:36 AM -0400 8/29/01, Jeremy Morano wrote:
>Hi ,
>
>this is my query
>
>SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id;
>
>this works correctly. The results are what they are supposed to be:
>However, when I change the = sign to a <> or !=, The results are completely
>inco
And that is correct.
You are getting each users.uid that doesn't match each picks.userid.
Jeremy Morano wrote:
> Hi ,
>
> this is my query
>
> SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id;
>
> this works correctly. The results are what they are supposed to be:
> However,
Hi ,
this is my query
SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id;
this works correctly. The results are what they are supposed to be:
However, when I change the = sign to a <> or !=, The results are completely
incorrect.
--
picks.user_i
