List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 29 2001 3:08pm
Subject:Re: im puzzled
View as plain text  
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, when I change the = sign to a <> or !=, The results are completely
> incorrect.
> 
> ----------------------------------
> 
> picks.user_id contains: 5, 1, 7, 8, 9, 12, 13, 15
> 
> users.uid contains: 1, 8, 9, 5, 7, 10, 11, 12, 13, 14, 15
> 
> 
> the result for SELECT users.uid FROM users, picks WHERE users.uid =
> picks.user_id; is:
> 
> 5, 1, 7, 8, 9, 12, 13, 15
> 
> and the result for SELECT users.uid FROM users, picks WHERE users.uid <>
> picks.user_id; is:
> 
> 1, 7, 8, 9, 10, 11, 12, 13, 14, 15, 5, 7, 8, 9, 10, 11,12, 13, 14, 15, 1, 5,
> 8, 9, 10 ,11...etc
> 
> it goes on for 80 rows with no particular pattern......H.E.L.P.!.
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread83901@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
im puzzledJeremy Morano29 Aug
  • Re: im puzzledGerald Clark29 Aug
  • Re: im puzzledPaul DuBois29 Aug
  • Re: im puzzledGerald Clark29 Aug