DB2 sql不支持join的？解决办法

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 x
WHERE EXISTS (
    SELECT 1 FROM ProdChanges
    WHERE ProdChanges.ITMNUMBER=x.ITMNUMBER
      and x.processingStatus='ERPQUE'
)