27,582
社区成员




declare @File_id int
set @File_id=?--某个值
select
Longitude as 经度,
Latitude as 维度,
国家=(select PLACE_NAME FROM tb2 WHERE Place_ID=t.CountryID),
省份=(select PLACE_NAME FROM tb2 WHERE Place_ID= t.ProvinceID ),
市=(select PLACE_NAME FROM tb2 WHERE Place_ID=t.CityID ),
县=(select PLACE_NAME FROM tb2 WHERE Place_ID=t. CountyID )
from tb1 t
where [FILE_ID]=@File_id
declare @File_id int
set @File_id=?--某个值
select
Longitude as 经度,
Latitude as 维度,
国家=(select PLACE_NAME FROM tb2 WHERE Place_ID=t.国家ID),
省份=(select PLACE_NAME FROM tb2 WHERE Place_ID=t.省份ID),
市=(select PLACE_NAME FROM tb2 WHERE Place_ID=t.市ID),
县=(select PLACE_NAME FROM tb2 WHERE Place_ID=t.县ID)
from tb1 t
where [FILE_ID]=@File_id
select a.file_id,'经度'=a.Longitude, '纬度'=a.Latitude,
国家=b.Place_Name,省=c.Place_Name,市=d.Place_Name,县=e.Place_Name
from ta a
left join tb b on a.CountryID=b.Place_ID
left join tb c on a.ProvinceID=c.Place_ID
left join tb d on a.CityID=d.Place_ID
left join tb e on a.县ID=e.Place_ID
Select A.Place_Name as '国家名称', B.Place_Name as '省份'
,C.Place_Name as '城市名称',D.Place_Name as '县名'
from 表1
inner join 表2 as A on 表1.CountryID =A.Place_ID
inner join 表2 as B on 表1.ProvinceID =B. Place_ID
inner join 表2 as C on 表1.CityID =C. Place_ID
inner join 表2 as D on 表1.CountyID =D. Place_ID