sql worked with some version and not with other
Posted 02 August 2006 - 04:28 PM
i have a table classified_city which contains
I have this query:
"select name from classified_city where idn=(select subcity_idn from classified_city where idn='2')"
This query does work on my local server, which run mysql 4.1.12 but does not work on remote server which I presume running a older version. (i do not know which version they're running).
Can anybody correct the syntax of that query so it would work with older version?
Posted 02 August 2006 - 04:56 PM
select c1.name from classified_city AS c1 join classified_city AS c2 on ( c1.idn = c2.subcity_idn ) where c2.idn='2'
Posted 03 August 2006 - 04:32 AM
It worked on both server, and faster too.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users