求个省市区三个表 合并一个表的SQL语句，格式如下！
0
最佳答案
0
用 union all，把所有结果集拼接：
select distinct * from
(select '省'=ProvinceName,'市'=null,'区'=null from Province with(nolock)
union all
select '省'=p.ProvinceName,'市'=ct.cityName,'区'=null from Province p with(nolock) left join city ct on p.ProvinceID = ct.ProvinceID
union all
select '省'=p.ProvinceName,'市'=ct.cityName,'区'=c.countryname from Province p with(nolock) left join city ct on p.ProvinceID = ct.ProvinceID left join country c on c.cityid = ct.cityid) t
order by t.省 desc
收获园豆：15
其他回答(3)
0
select concat(ProvinceName,cityname,counttryname) AS address
from a join b.....
join c ....
0
这是要做三级联动下拉框吗？
0
select city1.name as '一级地名',
city2.name as '二级地名',
city3.name as '三级地名'
from city as city1 inner join city as city2 on city1.parentid = 0 and city1.id = city2.parentid
inner join city as city3 on city2.id = city3.parentid
