大侠 谢了。 在帮我看看这个 select City_ID,City_Name,City_pinyin from letsno1_City where city_hot=1 order by (select City_Num from letsno1_city A join letsno1_city B on A.city_id = B.city_parentid order by A.City_Num)
select City_ID,City_Name,City_pinyin from letsno1_City where city_hot=1 order by (select distinct City_Num from letsno1_city A join letsno1_city B on A.city_id = B.city_parentid order by A.City_Num)
[SQL] select City_ID,City_Name,City_pinyin from letsno1_City where city_hot=1 order by (select distinct City_Num from letsno1_city A join letsno1_city B on A.city_id = B.city_parentid order by A.City_Num)[Err] 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 '' at line 3出现这个错误
select City_ID,City_Name,City_pinyin from letsno1_City where city_hot=1 order by (select City_Num from letsno1_city A join letsno1_city B on A.city_id = B.city_parentid order by A.City_Num)
from letsno1_City where city_hot=1 order by
(select distinct City_Num from letsno1_city A join letsno1_city B on A.city_id = B.city_parentid order by A.City_Num)
from letsno1_City where city_hot=1 order by
(select distinct City_Num from letsno1_city A join letsno1_city B on A.city_id = B.city_parentid order by A.City_Num)[Err] 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 '' at line 3出现这个错误