Jump to content

Archived

This topic is now archived and is closed to further replies.

hvle

sql worked with some version and not with other

Recommended Posts

hi guys,

i have a table classified_city which contains
idn: interger
name: varchar
subcity_idn: integer

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?


Thanks


Share this post


Link to post
Share on other sites
You might as well use a self-join (UNTESTED):

[code]select c1.name from classified_city AS c1
join classified_city AS c2 on ( c1.idn = c2.subcity_idn )
where c2.idn='2'
[/code]

Share this post


Link to post
Share on other sites
Thank you so much,
It worked on both server, and faster too.

Share this post


Link to post
Share on other sites
No problem.. JOINs are almost always faster than sub-queries, more portable, and IMHO, easier to understand and maintain.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.