SELECT
temp_table.*,t_prov_city_area_street. NAME AS area_name //③查询表temp_table,name作为 area_name
FROM
(
SELECT //①查询表 t_score_table,1作为 is_self
t_score_table.*, 1 AS is_selef
FROM
t_score_table
WHERE
t_score_table.area_id = 1301
AND t_score_table.type = 0
) AS temp_table //②查询结果作为 表temp_table
LEFT JOIN t_prov_city_area_street ON t_prov_city_area_street.id = temp_table.area_id / /④链接 表t_prov_city_area_street
LIMIT 0,
10;
结果