关于Merge into语法
小弟初学DB2,现有一句MS SQL2005 的语句需要转为DB2,需要用到Merge into,但不知道遇到Left join的语句该怎么写
--MS SQL2005
Update A
Set A.xValue=B.xValue
From skyPay_Working A
Inner Join skyPayItems I On (I.PGID=@PGID) And (A.ID=I.ID) And (I.Reserved=1)
Left Join #skyPay B On (A.PEID=B.PEID And A.ID=B.ID)
Where (A.JSID=@JSID)
And Exists(Select 1 from #skyPay_Working c Where a.PEID=c.PEID);