select DISTINCT WA.NF AS YEAR ,WA.STATIONCODE AS CODE_STATION, WA.STATIONNAME AS STATIONNAME, WA.SECTION_CODE AS CODE_SECTION,WA.SECTION_NAME AS SECTIONNAME,WA.SSHL AS RIVENAME,BA.LAKE_NAME AS LAKENAME,WA.REGIONNAME AS REGIONNAME, WA.SECTIONLEVEL AS CODE_WATERLEVEL,WA.LONGITUDE AS LONGITDE,WA.LATITUDE AS LATITUDE from t_base_water_riversection WA lefter JOIN T_BASE_WATER_LAKEINFO BA ON WA.STATIONCODE=BA.STATIONCODE where 1=1
表一 :t_base_water_riversection
表二:T_BASE_WATER_LAKEINFO