救命呀!!!!!!!!!!!求一条sql语句

[renco]

details表
id goodsid sellname ...
02845020060920000045 1 箱
02845020060922000087 1 件
02845020061012000005 2 箱
02845020061012000006 2 箱
02845020061211000032 3 袋
02845020061222000003 3 件
02845020070112000041 3 件
02845020070225000013 4 袋
51000020070412000058 5 袋
51000020070417000009 5 袋
51000020070417000408 5 件
51000020070418000094 6 袋
51000020070418000877 51 件
51000020070423001108 162 袋
...
=============================
goods表
goodsid prices ...
1 123
2 328
...
=============================
unit表
id goodsid name
1 1 袋
2 1 箱
3 2 件
4 2 袋
5 3 瓶
6 4 卷
7 ...
现在要查询出details表中
销售的商品(goodsid) sellname 未在单位表(unit表)中出现过的记录
例如:
02845020061012000005 2 箱
02845020061012000006 2 箱

[jiazheng]

select * from details v
where not exists
(
select 1 from unit t where t.goodsid=v.goodsid and t.name=v.sellname
)