删除条件，复杂来看

[blueonly]

表ClassTable
字段GoodsId
例GoodsId
1
1
2
2
3
4
_________________
表GoodsTable
字段GoodsId (KEY)
例
GoodsId
1
2
3
4
5
7
___________________
删除GoodsTalbe中GoodsId不在ClassTable中存在的记录
我想写个过程，可能实现吗？

[LoveSQL]

delete GoodsTalbe where GoodsId not in(select distinct GoodsId from ClassTable)

[qiaolin53]

delete from GoodsTable where GoodsID not in (select GoodsID from ClassTable)

[gmlxf]

delete GoodsTalbe where GoodsId not in(select GoodsId
from ClassTable)

[yy007]

这个语句我已经测试过了，可以实现你的功能！

delete goodstalbe where goodstalbe.goodsid not in(select classtalbe.goodsid where classtalbe)

[yy007]

刚才我写错了，我把from写成where了！
delete goodstalbe where goodstalbe.goodsid not in(select classtalbe.goodsid from classtalbe)

[sxsgssgs]

我修改了一下 Symsan() 的。这下完全正确，我已经试过了。
CREATE PROCEDURE pro_del
AS
delete from GoodsTable where GoodsId not in(select GoodsId
from ClassTable)
GO

[pwzhu666]

delete from GoodsTalbe where GoodsId not in(select GoodsId from ClassTable)

[lynx1111]

delete from GoodsTalbe where GoodsId not in(select GoodsId
from ClassTable)

[dlpseeyou]

delete from GoodsTalbe where GoodsId not in(select GoodsId from ClassTable) a

[Symsan]

CREATE PROCEDURE pro_del
AS
delete from GoodsTalbe where GoodsId not in(select GoodsId
from ClassTable)
GO

[blueonly]

第一个就好使，感觉自己没用，啥都的问人，谢谢你门了，给分了

[zjcxc]

delete GoodsTalbe
from GoodsTalbe a left join GoodsTable b on a.GoodsId=b.GoodsId
where b.GoodsId is null

[victorycyz]

delete a from goodstable a left join goodsid b on a.goodsid=b.goodsid where b.goodsid is null

最好是goodstable中建一个触发器，goodstable中插入记录时就判断goodsid中有没有相应的记录。 goodsid中建一个删除触发器，同时删除goodstable中的相应的记录。

[sdhdy]

delete GoodsTalbe where GoodsId not in(select distinct GoodsId from ClassTable)

[blueonly]

我感觉第一种比较直观，总的来说不知道哪个更好