请帮忙写出SQL语句

[prettyBoy2002]

有两个表他们结构一样，如A(nodekey,name,bz)和B(nodekey,name,bz)
A表中nodekey和name为主键，B表中也是nodekey和name为主键。
写出SQL语句，检索出同时满足条件（1)在B表中存在而在A表中不存在的记录集.(2)B表的bz>5。

我只知道满足条件（1）写法为：select * from B where not exists (select *
from A
where A.nodeky=B.nodeky and A.name=B.name)

[dafu71]

select * from B where not exists (select * from A
where A.nodeky=B.nodeky and A.name=B.name) and bz>5

[CrazyFor]

select * from B where not exists (select *
from A
where A.nodeky=B.nodeky and A.name=B.name) and b.bz>5

[pengdali]

select * from B where not exists (select * from A where A.nodeky=B.nodeky and A.name=B.name) and bz>5

[CrazyFor]

OR:

select b.* from B表 b left join A表 a on a.nodekey=b.nodekey and a.name=b.name
where a.nodekey is null and b.bz>5

[amtyuranus]

select * from B where not exists (select * from A
where A.nodeky=B.nodeky and A.name=B.name) and bz>5

[amtyuranus]

哈哈，都一个吊样

[waitwater]

select * from B where not exists (select * from A where A.nodeky=B.nodeky and A.name=B.name) and bz>5

[CrazyFor]

OR:

select b.* from B表 b left join A表 a on a.nodekey=b.nodekey and a.name=b.name
where a.nodekey is null and b.bz>5

[zjcxc]

select * from B where not exists (select 1 from A where A.nodeky=B.nodeky and A.name=B.name) and bz>5