FW: correction to JOIN
| From: | Jeremy Morano | Date: | Thu, 30 Aug 2001 16:08:54 +0000 |
| Subject: | FW: correction to JOIN | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-65312@lists.php.net to get a copy of this message | ||
-----Original Message-----
From: Jeremy Morano [mailto:jeremy@prepresshelp.com]
Sent: Thursday, August 30, 2001 12:05 PM
To: php-general@lists.php.net
Subject: JOIN
Sorry everone but I 'm having a hard time with joins
How do I add this clause:
users.uid <> selection.user_uid from table selection
to this query:
$sql = "SELECT users.uid, users.username
FROM users LEFT JOIN picks
ON users.uid = picks.user_id
WHERE picks.user_id IS NULL
Thank You.