I don't believe MySQL supports sub queries yet. I could be wrong. I would double check this on MySQL.com Make sure you check against the version you have installed. The other piece of your puzzle requires an outer join.
Andrey wrote: > > 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
