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';
[解决办法]
DELETE FROM ProdChangesXRef xWHERE EXISTS ( SELECT 1 FROM ProdChanges WHERE ProdChanges.ITMNUMBER=x.ITMNUMBER and x.processingStatus='ERPQUE')
