MySQL Forums
Forum List  »  MyISAM

How to solve the problem for this query
Posted by: Arul M
Date: March 15, 2006 02:59AM

Hi,

I have use the subquery like this.whats the prolem to solve this solution .It execute in local machine.(mysql 4.1x)

But it gives error in server.(mysql 3.3x)

Is there any mysql version problem?


SELECT * FROM data WHERE datatype='data' and project_status='0' and data_id = (SELECT data_id FROM data_relation WHERE child_to = '20') 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 data_id FROM data_relation WHERE child_to = '20')' at li


Regards
Arul.m

Options: ReplyQuote


Subject
Views
Written By
Posted
How to solve the problem for this query
2460
March 15, 2006 02:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.