WTH is wrong with this MySql statement?

[alex79]

SELECT id FROM `table1` WHERE id NOT IN ( SELECT id FROM `table2` )

i get an #1064 - You have an error in your SQL syntax near 'SELECT id FROM `table1` error message

[FuqALot]

try `table1` without quotes, and `table2` without quotes too.

and fyi, u need a pretty new mysql version to use query with query.. but first u should try without the quote.

[psili]

You could try:

SELECT id FROM table1 LEFT JOIN table2 WHERE table2.id IS NULL

[CaptainHowdy]

You could try:

SELECT id FROM table1 LEFT JOIN table2 WHERE table2.id IS NULL

!!