请教这个sql怎么写
MS SQL server里的sql
DELETE x
FROM ProdChangesLastTxn x
JOIN ProdChanges p
ON p.STOCK_ID = x.STOCK_ID
WHERE p.processingstatus='ERPSUC'

我在DB2里sql怎么写？
谢谢

[解决办法]
Delete from ProdChangesLastTxn where STOCK_ID in (select STOCK_ID from ProdChanges where processingstatus='ERPSUC')
[解决办法]

SQL code

delete from ProdChangesLastTxnwhere exists (    select 1 from ProdChanges    where ProdChangesLastTxn.STOCK_ID = ProdChanges.STOCK_ID      and ProdChangesLastTxn.Prod = ProdChanges.Prod      and ProdChanges.processingstatus='ERPSUC')