Subquery mysql dont work

cuencano · 08-02-2005, 04:20 PM

i have a query in mysql but dont work, please help me????
the query is:

mysql> Select field1 from table1 where field1 in ( select field1 from table2);

ERROR 1064: You have an error in your SQL syntax near 'select field1 from table2)' at line 1

Thanks

vharishankar · 08-03-2005, 12:30 AM

You might find this useful: it's a good reference manual.
http://dev.mysql.com/doc/mysql/en/select.html

Check the syntax of your SQL query. I am not quite sure, but just looking at that query it looks wrong.