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]
