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?
I can only figure it out if I use two queries.
$result=mysql_query("SELECT id,item FROM table1");
while ($row=mysql_fetch_array($result)) {
$thisid=$row["id"];
I'm not 100% certain about this, but I believe you want to look at using a
LEFT OUTER JOIN
At 11:37 AM 4/4/01 -0400, bill 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?
I can only figure it out if I use two
"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
3 matches
Mail list logo