Re: [PHP-DB] query that finds when something is NOT IN a table

2003-03-06 Thread Paul Burney
on 3/6/03 4:59 PM, Katie Evans-Young at [EMAIL PROTECTED] appended the following bits to my mbox: > I need to only return a row from table1 if its id is not found in table2. > The query below is how I think it should work. However (as I had imagined), > this doesn't work. Syntax error (you can't p

[PHP-DB] query that finds when something is NOT IN a table

2003-03-06 Thread Katie Evans-Young
(Using MySQL and PHP) I need to only return a row from table1 if its id is not found in table2. The query below is how I think it should work. However (as I had imagined), this doesn't work. Syntax error (you can't put a select inside a select like that). SELECT table1.id FROM table1 WHERE table1