| skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResDykeMapper.xml | ●●●●● patch | view | raw | blame | history |
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResDykeMapper.xml
@@ -96,6 +96,9 @@ from sjzt_md."tb_res_dyke" trd left join "SJZT_MD"."tb_dyke_investigation_state" tdis on trd."guid" = tdis."dyke_guid" left join YWXT."att_ad_base" aa on aa."guid" = trd."ad_code" left join YWXT."att_ad_base" ab on ab."ad_code" = aa."p_ad_code" left join YWXT."att_ad_base" ac on ac."ad_code" = ab."p_ad_code" left join YWXT."att_ad_base" ad on ad."ad_code" = ac."p_ad_code" left join ( select