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
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