查询省、市、县

select distinct Cast(C.SystemAreaName as varchar(10))+'-'+cast(B.SystemAreaName as varchar(10))+'-'+cast(A.SystemAreaName as varchar(10)) as 地址 from[Order] o, SystemArea A
LEFT JOIN SystemArea B
ON A.ParentID = B.SystemAreaID
LEFT JOIN SystemArea C
ON B.ParentID = C.SystemAreaID
where A.SystemAreaID=o.DistrictId

select C.SystemAreaName 省,B.SystemAreaName 市,A.SystemAreaName 县 from[Order] o, SystemArea A
LEFT JOIN SystemArea B
ON A.ParentID = B.SystemAreaID
LEFT JOIN SystemArea C
ON B.ParentID = C.SystemAreaID
where A.SystemAreaID=o.DistrictId