select *  from A where nos='TEST001' and not exists (select 1  from  B where nos ='Test001')


select *  from A where nos='TEST001' and  exists (select 1  from  B where nos ='Test001' and A.gxrq<>B.gxrq)

------解决方案--------------------
try
SQL code
select a.* from a 
where nos='Test001'
and
(not exists(select 1 from b where nos=a.nos)
or
exists(select 1 from b where nos=b.nos and gxrq!=a.gxrq)
)

------解决方案--------------------
沒明白哈~！只查具體的某張單？

SQL code

select *
from a
where exists (select 1 from b where nos = a.nos and gxrq <> a.gxrq)
   or not exists (select 1 from tb where nos = a.nos)

------解决方案--------------------
建议给出测试数据及你想要的结果。

SQL code
select * from A表 a where nos='Test001'
and 
( not exists (select top 1 * from B表 b where b.nos=a.nos)
or
exists (select top 1 * from B表 b where b.nos=a.nos and a.gxrq<>b.gxrq)
)

------解决方案--------------------
SQL code

--得到一個具體的單號 @nos 和 gxrq 值 @gxrq 傳輸的。
if exists (select 1 from b where nos = @nos and gxrq <> @gxrq)
   or not exists (select 1 from tb where nos = @nos)
--傳輸處理

--或者

--傳輸處理的SQL
insert into ...
select ...
from a,...
where a.nos = '' and ....
  and exists (select 1 from b where nos = a.nos and gxrq <> a.gxrq) --加where條件後邊
   or not exists (select 1 from tb where nos = a.nos)

------解决方案--------------------
这太绕了，
SQL code

select * from a where nos='test001' and (not exists(select nos from b where nos=a.nos)
or
exists(select nos from b where nos=b.nos and gxrq!=a.gxrq)
)

------解决方案--------------------
有点绕啊
SQL code

select * from a where nos='test001' and (not exists(select nos from b where nos=a.nos)
or
exists(select nos from b where nos=b.nos and gxrq!=a.gxrq)
)

------解决方案--------------------
select *
from a
where exists (select 1 from b where nos = a.nos and gxrq <> a.gxrq)
  or not exists (select 1 from tb where nos = a.nos)


------解决方案--------------------
我是看标题进来的，你自己看着办吧

------解决方案--------------------
SQL code


CREATE TABLE TA(NOS VARCHAR(20),GXRQ INT)
CREATE TABLE TB(NOS VARCHAR(20),GXRQ INT)

INSERT INTO TA VALUES('Test001',1),('Test002',1),('Test003',1)
INSERT INTO TB VALUES('Test004',1),('Test002',1),('Test003',2)

SELECT * FROM TA A
WHERE EXISTS(SELECT * FROM TB B WHERE A.NOS=B.NOS AND A.GXRQ<>B.GXRQ )
OR NOT EXISTS(SELECT * FROM tb B WHERE A.NOS=B.NOS AND A.GXRQ=B.GXRQ)