JOIN
| From: | Jeremy Morano | Date: | Thu, 30 Aug 2001 16:04:48 +0000 |
| Subject: | JOIN | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-65305@lists.php.net to get a copy of this message | ||
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.