| skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/jcsb/mapper/DbReporttMapper.xml | ●●●●● patch | view | raw | blame | history |
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/jcsb/mapper/DbReporttMapper.xml
@@ -137,7 +137,7 @@ DATE_FORMAT(SDR.RECORD_TIME,'%Y-%m') as reportTime, AVG(SDR.de_val) as deVal, AVG(SDR.dn_val) as dnVal, AVG(SDR.du_val) as duVal, AVG(SDR.du_val) as duVal FROM SM_DB_REPORT SDR LEFT JOIN SJZT_MD."att_wy_cd_base" awcb ON awcb."res_cd" = sdr.reservoir_id and awcb."cd" = SDR.station_id WHERE SDR.is_deleted = 0
