34,575
社区成员
发帖
与我相关
我的任务
分享
select * from a where not exists(select * from b where a.a=b.c and a.b=b.d)
select a from 表A t where not exists(select 1 from 表B where t.a=c or t.b=d)
写错,改下.select a from 表A t where not exists(select 1 from 表B where t.a=c or t.a=d)
SELECT *
FROM A
WHERE NOT EXISTS(SELECT * FROM B WHERE A.a=B.c OR A.b=B.d)