From e4cb72ce0502ca1006727198cd77264b14fda78e Mon Sep 17 00:00:00 2001 From: zc <zc> Date: 星期三, 24 七月 2024 11:09:48 +0800 Subject: [PATCH] 视图 --- src/main/java/asr_show_diff.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/java/asr_show_diff.sql b/src/main/java/asr_show_diff.sql index 6b1df35..f06fdb0 100644 --- a/src/main/java/asr_show_diff.sql +++ b/src/main/java/asr_show_diff.sql @@ -7,7 +7,7 @@ FROM ( SELECT CAST - ( SUM ( qty ) AS INT ) asrsQty, + ( SUM ( anfme ) AS INT ) asrsQty, 0 AS erpQty, matnr, specs, -- Gitblit v1.9.1