From 55a58c8b92ac2dae836bc53bfbf52f8f8afab86f Mon Sep 17 00:00:00 2001
From: yxm <zhp1521624>
Date: Fri, 05 Jul 2024 10:26:07 +0800
Subject: [PATCH] 堤防水库危害统计sql逻辑修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResAndDykeAllMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResAndDykeAllMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResAndDykeAllMapper.xml
index eefb432..cfa745f 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResAndDykeAllMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResAndDykeAllMapper.xml
@@ -57,7 +57,7 @@
g."guid" AS provinceCode
FROM
"SJZT_MD"."att_res_base" a
- RIGHT JOIN ( SELECT * FROM "SJZT_MD"."tb_res_general_investigation_state" WHERE "danger_level" <![CDATA[<>]]> '0' AND "check_state" = '3' ) c ON a."guid" = c."res_guid"
+ LEFT JOIN ( SELECT * FROM "SJZT_MD"."tb_res_general_investigation_state" WHERE "danger_level" <![CDATA[<>]]> '0' AND "check_state" = '3' ) c ON a."guid" = c."res_guid"
LEFT JOIN YWXT."att_ad_base" d ON d."ad_code" = a."interior_ad_guid"
LEFT JOIN YWXT."att_ad_base" e ON d."p_ad_code" = e."ad_code"
LEFT JOIN YWXT."att_ad_base" f ON e."p_ad_code" = f."ad_code"
@@ -105,7 +105,7 @@
f."guid" AS provinceCode
FROM
"SJZT_MD"."tb_res_dyke" a
- RIGHT JOIN (
+ LEFT JOIN (
SELECT
a.*
FROM
--
Gitblit v1.9.3