From 88b03643e0e28a9e27eb61f1d8566a45b908a4bf Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期三, 16 八月 2023 10:21:56 +0800
Subject: [PATCH] #
---
src/main/resources/mapper/LocDetlMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 82b0450..6a64a57 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -219,7 +219,7 @@
ROW_NUMBER() over (order by sum(a.anfme) desc) as row
, a.matnr
, sum(a.anfme) as anfme
- from asr_loc_detl a
+ from asr_loc_detl_all a
where 1=1
group by a.matnr
</select>
--
Gitblit v1.9.1