SQL 查询

 

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"