HEllo,
I think this will better work. What Jeremy wants to do is
to OUTER joing the tables:
SELECT distinct users.uid , users.username
FROM users LEFT OUTER JOIN picks using(uid)
may do the trick.
If you say letf join and the use ids not equal in the
where, then I think it's same as saying:
wher
I don't know if this will help but why not to try
$sql = "SELECT distinct users.uid , users.username
FROM users LEFT JOIN picks USING(uid)
WHERE picks.users_uid <> users.uid
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message -
From: "Jeremy Morano" <[EMAIL P
Hello Jeremy,
you are using two tables, but you are not joining them.
What's you goal?
--- Jeremy Morano <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Can somebody help me out?
> My where clause is completely being ignored.
> More specifically the <>. I tried to use != and that
> didn't work either.
> Ho
3 matches
Mail list logo
