Bug #11937 Error Code : 1064

• Submitted: 14 Jul 2005 13:15
• Modified: 14 Jul 2005 13:23
• Reporter: Venkat Ramanujam
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 4.0.18-nt
• OS: Windows (Windows 2000 SP4)
• CPU Architecture: Any

[14 Jul 2005 13:15] Venkat Ramanujam

Description:
I am using the following query in sqlyog sql editer screen... the following errors show in result pane.

Query...:

Select * from t1 where field1 = (select field1 from t2)

Error...:

Error Code : 1064
You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT FIELD1 FROM T2)' at line 1

Kindly Help how to execute the query.....

With Regards
N V Ramanujam.

How to repeat:
Select * from t1 where field1 = (select field1 from t2)

[14 Jul 2005 13:23] Aleksey Kishkin

in mysql subselects work from version 4.1

[8 Sep 2008 6:35] subh prakash

Please use following code

select * from t1 where field1 in (select field1 from t2);