Error in SQL syntax

[vodero]

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 --

[inder]

It seems as mysql 3.3x can't support this sql statement. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --