SELECT fang_time, city_name, IF(AREA IS NULL,0,AREA) AS arra, IF(taoshu IS NULL,0,taoshu) AS taoshu FROM f_city AS fc INNER JOIN (SELECT * FROM f_chengjiao ORDER BY fang_time DESC) AS fcj USING (city_id) ORDER BY fcj.fang_time DESC你要的是不是这样的,如果不是欢迎追问。
FROM f_city AS fc INNER JOIN
(SELECT * FROM f_chengjiao ORDER BY fang_time DESC) AS fcj
USING (city_id) ORDER BY fcj.fang_time DESC你要的是不是这样的,如果不是欢迎追问。