On 31/05/2005, Lucio Crusca wrote: > I use mysql 4.0.24 as found in debian gnu/linux sarge. > mysql> select * from SAMPLES S1 where exists (select * from SAMPLES > S2 where S1.ID = S2.ID); > > ERROR 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 'exists (select * from SAMPLES S2 where S1.ID = S2.ID)' at > line
You need MySQL 4.1.x for subqueries. -- felix -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
