Re: subqurey syntax error

2004-01-26 Thread Nitin Mehta
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

subqurey syntax error

2004-01-25 Thread 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