34,837
社区成员




SELECT * FROM B WHERE NAME NOT IN (SELECT NAME FROM A)
select * from @tb b where not exists(select 1 from @ta where 姓名=b.姓名)
select b.* from @tb b left join @ta a on b.姓名=a.姓名
where a.姓名 is null
select * from B
where B.姓名 not in
(
select 姓名 from A
)