| skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml | ●●●●● patch | view | raw | blame | history |
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml
@@ -267,7 +267,7 @@ group by tdi."tb_state_id",tdi."dyke_guid",tdi."unit" )TEMP1 ) tdi on tdi."tb_state_id" = tdis."guid" where (tdis."check_state" = 1 or tdis."check_state" = 2) where (tdis."check_state" = 3) ) trd LEFT JOIN YWXT."att_ad_base" county ON county."ad_code" = trd."ad_code" LEFT JOIN YWXT."att_ad_base" city ON city."ad_code" = county."p_ad_code"
