From 9d2d7c23cea8d50716b4bf1272557001ee7874f5 Mon Sep 17 00:00:00 2001 From: czkh <czkh@163.com> Date: 星期一, 03 十一月 2025 18:02:58 +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 4282ce4..714621a 100644 --- a/src/main/java/asr_show_diff.sql +++ b/src/main/java/asr_show_diff.sql @@ -41,7 +41,7 @@ itembatch AS batch, itemSpc specs FROM - ( SELECT * FROM OPENROWSET ( 'SQLOLEDB', '192.168.1.147,1800'; 'XGMLK'; 'xunda0413', XDLinkLK.dbo.vwErpLKStorage ) WHERE LKName = '涓壃浜屾湡' ) a + ( SELECT * FROM OPENROWSET ( 'SQLOLEDB', '192.168.1.147,1800'; 'XGMLK'; 'xunda0413', XDLinkLK.dbo.vwErpLKStorage ) WHERE LKName = '楂橀湒绔嬪簱' ) a GROUP BY itemid, itemcode, -- Gitblit v1.9.1