From af4b93104f60c8061b3887cce627730f29e983ac Mon Sep 17 00:00:00 2001 From: lty <876263681@qq.com> Date: 星期六, 17 五月 2025 14:42:46 +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