Re: EXISTS

[Felix Geerinckx]

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