Dim sql1 As String = "SELECT Ams_Position.id_ams_position, Ams_Position.name_ams,Ams_Position.code_ams,Country.CountryName,CountyCity.CountyCityName,District.DistrictName,UserType.TypeName,DistrictGroup.GroupName from Ams_Position" & _
" LEFT JOIN Country ON Ams_Position.idCountry=Country.idCountry" & _
" LEFT JOIN CountyCity ON Ams_Position.idCountyCity=CountyCity.idCountyCity" & _
" LEFT JOIN District ON Ams_Position.idDistrict=District.idDistrict " & _
" LEFT JOIN UserType ON Ams_Position.idUserType=UserType.idUserType " & _
" left join DistrictGroup on DistrictGroup.idDistrictGroup = (select top 1 DistrictGroupList.idDistrictGroup from DistrictGroupList where DistrictGroupList.idDistrict = Ams_Position.idDistrict) WHERE 1 = 1"
SQL 查询
最新推荐文章于 2022-07-02 16:17:50 发布