Hi, I'm using MySQL 4.0.15 and have been trying to use EXISTS/NOT EXISTS ... with no success - getting "You have an error in your SQL syntax".
I've got 2 tables A and B and am trying something like this SELECT THIS.A_ID FROM A THIS WHERE NOT EXISTS (SELECT THIS_ITEMS.B_ID FROM B THIS_ITEMS WHERE THIS.A_ID=B.A_ID) Does EXISTS exist in 4.0.15 ? or is it introduced in 4.1.*. If it does exist, what is incorrect in the syntax above ? (it matches the MySQL manual example from what I can see). TIA -- Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]