"bill" <[EMAIL PROTECTED]> wrote:
> If I want to find a list of items in one table whose id does not appear
> in another table, can that be done in one query?
Absolutely.
SELECT *
FROM table_1
LEFT JOIN table_2 on table_2.id = table_1.id
WHERE table_2.id IS NULL
Read about LEFT JOINs in the manual.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
