Hi all, What is wrong with this query:
select * from MYTABLE where MYTABLE.entry NOT IN (select ANOTHERTABLE.entry from ANOTHERTABLE) mysql gives me a sintax error that looks like this: ERROR 1064: You have an error in your SQL syntax near 'select ANOTHERTABLE.entry from ANOTHERTABLE)' at line 1 does mysql support complex queries? is there any way to select something from one table that IS NOT in the other? I tried stuff like joining two tables (MYTABLE and ANOTHERTABLE) and putting conditions : MYTABLE.entry != ANOTHERTABLE.entry but that does not work for some reason. Also, keep in mind that MYTABLE.entry and ANOTHERTABLE.entry both of the type varchar(50) thanks in advance, Andrey
