Thread: Error in SQL syntax
View Single Post
  #1  
Old 05-22-2007, 02:12 AM
vodero vodero is offline
Junior Member
  
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
vodero is on a distinguished road
Default Error in SQL syntax
Hi all,
I use the following sub-query but got some problem. It execute in local machine (mysql 4.1x) but gives error in server.(mysql 3.3x).

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

Any hint how to sole this problem? Thanx!! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - Error in SQL syntax
Thread: Error in SQL syntax
View Single Post
  #1  
Old 05-22-2007, 02:12 AM
vodero vodero is offline
Junior Member
  
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
vodero is on a distinguished road
Default Error in SQL syntax
Hi all,
I use the following sub-query but got some problem. It execute in local machine (mysql 4.1x) but gives error in server.(mysql 3.3x).

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

Any hint how to sole this problem? Thanx!! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote