DB2 sql不支持join的？
sql server的
FROM EODSHADOW.ProdChangesXRef pcx
INNER JOIN CWMUDTA.INITEM p
ON pcx.ITMNUMBER=p.ITMNUMBER
LEFT JOIN CWMUDTA.INSKU s
ON s.BJBECD=pcx.ITMNUMBER
LEFT JOIN CWMUDTA.POVNIT pov
ON pov.ITMNUMBER=pcx.ITMNUMBER AND pov.SKUCODE=s.SKUCODE

在db2里怎么写啊？

[解决办法]
DELETE FROM ProdChangesXRef x WHERE EXISTS
(SELECT 1 FROM ProdChanges
WHERE ProdChanges.ITMNUMBER=x.ITMNUMBER) WHERE x.processingStatus='ERPQUE';
[解决办法]

SQL code

DELETE FROM ProdChangesXRef xWHERE EXISTS (    SELECT 1 FROM ProdChanges    WHERE ProdChanges.ITMNUMBER=x.ITMNUMBER      and x.processingStatus='ERPQUE')