22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT DISTINCT A2,A8 FROM YHJ_TEMPFFGG73 WHERE A8 LIKE '%135S/4%'
SELECT * FROM xtm124 WHERE wplbdm='07' AND wpsxmc LIKE '%135S/4%'
SELECT A8
FROM YHJ_TEMPFFGG73
WHERE LTRIM(RTRIM(A8)) NOT IN ( SELECT LTRIM(RTRIM(wpsxmc))
FROM xtm124
WHERE wplbdm = '07' )
SELECT DISTINCT LTRIM(RTRIM(A8)) FROM YHJ_TEMPFFGG73 WHERE NOT EXISTS
(SELECT 1 FROM xtm124 WHERE LTRIM(RTRIM(A8))=LTRIM(RTRIM(wpsxmc)) AND wplbdm='07')
CREATE TABLE YHJA
( A1 NVARCHAR(20))
INSERT YHJA VALUES('Y')
CREATE TABLE YHJB
( A1 NVARCHAR(20))
INSERT YHJB VALUES('YY')
SELECT * FROM YHJA WHERE A1 NOT IN (SELECT A1 FROM YHJB)
返回:
A1
Y
--测试数据
if not object_id(N'Tempdb..#YHJ_TEMPFFGG73') is null
drop table #YHJ_TEMPFFGG73
Go
Create table #YHJ_TEMPFFGG73([A2] int,[A8] nvarchar(26))
Insert #YHJ_TEMPFFGG73
select 8880309,N'135S/4' union all
select 8880310,N'135S/4' union all
select 8880311,N'135S/4'
GO
if not object_id(N'Tempdb..#xtm124') is null
drop table #xtm124
Go
Create table #xtm124([wplbdm] nvarchar(22),[wplbzb] nvarchar(22),[wpsxdm] nvarchar(25),[wpsxmc] nvarchar(32),[wpsxms] nvarchar(21),[wpsjsx] nvarchar(21))
Insert #xtm124
select N'07',N'00',N'07361',N'80S/4+135S/4',NULL,NULL
Go
--测试数据结束
SELECT A8
FROM #YHJ_TEMPFFGG73
WHERE LTRIM(RTRIM(A8)) NOT IN ( SELECT LTRIM(RTRIM(wpsxmc))
FROM #xtm124
WHERE wplbdm = '07' )
----------------
SELECT DISTINCT LTRIM(RTRIM(A8)) FROM #YHJ_TEMPFFGG73 WHERE NOT EXISTS
(SELECT 1 FROM #xtm124 WHERE LTRIM(RTRIM(A8))=LTRIM(RTRIM(wpsxmc)) AND wplbdm='07')