subqueries are introduced in 4.1 only
----- Original Message ----- From: "Emmanuel Ohannessian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 26, 2004 12:10 PM Subject: subqurey syntax error > 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
