请教这个SQL怎么写？多条件排除的查询！

[xjbs]

表A：dept,goodscode,price
表B：dept,goodscode,spmprice//特价
现要将出现在表B中各部门的商品不出现在对表A的查询中
例：
Table A:
0001 a01 1.5
0001 a02 2.2
0001 a03 4.8
...
0002 a01 1.5
0002 a02 2.0
0002 a03 3.6
....
Table B:
0001 a03 3.6
0002 a01 3.8


写一个查询
要求结果是这样的：
dept goods price
0001 a01 1.5
0001 a02 2.2
0002 a02 2.0
0002 a03 3.6

help!!:)

[dafu71]

select tableA.* from tableA,tableB where tableA.dept=tableB.dept and tableA.goods<>tableB.goods

[enhydraboy]

select a.dept,a.goods,a.price from A left outer join B on a.dept=b.dept and a.goods=b.goods
where b.price is not null

[enhydraboy]

sorry,更正
==>
select a.dept,a.goods,a.price from A left outer join B on a.dept=b.dept and a.goods=b.goods
where b.price is null

[enhydraboy]

sorry,更正
==>
select a.dept,a.goods,a.price from A left outer join B on a.dept=b.dept and a.goods=b.goods
where b.price is null

[愉快的登山者]

select * from 表A A where not exists (select * from 表B where dept = A.dept and goodscode = A.goodscode)

[伍子V5]

select A.* from A,B where A.dept=B.dept and A.goods<>B.goods

[pengdali]

select * from a where not exists(select 1 from b where dept=a.dept and goodscode=a.goodscode)

[pengdali]

select * from a where not exists(select 1 from b where dept=a.dept and goodscode=a.goodscode)

[pengdali]

select * from a where not exists(select 1 from b where dept=a.dept and goodscode=a.goodscode)

[txlicenhe]

没太看懂。

[liuyun2003]

乱舞好久不见了，在忙什么？？

[zarge]

select A.* from A left join B on A.dept = B.dept and A.goodscode = B.goodscode
where B.spmprice is null

OR

select * from A where not exists (select * from B where dept = A.dept and goodscode = A.goodscode)

[xjbs]

大受启发，，；）