MySQL Server Forum - Having problem with simple "NOT IN" query

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Having problem with simple "NOT IN" query

mantas44@hotmail.com

2005-08-20, 11:23 am

Hello all,

I have two tables

tab_a id(int)
tab_b id(int)

and I try the following select which returns an error:

SELECT id from tab_a
where id NOT IN
(select id from tab_b);

#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'select id from tab_b) LIMIT 0, 30' at line 3

Please advise.

Cheers,

Manny

mantas44@hotmail.com

2005-08-20, 11:23 am

Its ok folks I got it sorted, thanks anyway.

Sponsored Links