subqurey syntax error

[Emmanuel Ohannessian]

I am getting the error message: 
 
mysql> SELECT s1 FROM t1 WHERE s1 IN    (SELECT s1 FROM t2);
 
ERROR 1064: You have an error in your SQL syntax.  Check the manual that
corresp
onds to your MySQL server version for the right syntax to use near
'SELECT s1 FR
OM t2)' at line 1
mysql>
 
I am using MySQL version 4.0.17, on windows xp professional.
 
Has anyone encountered this problem before? Please help.
 
 
 
Emmanuel Ohannessian