Update TD SET TD.Z_DDRQ=TM1.PayDate from PRPay TM LEFT JOIN PRPayA TD ON TM.DocEntry=TD.DocEntry LEFT JOIN PRPin TM1 ON TD.BaseDocNum=TM1.DocEntry 如上,PRPay为当前单据,这个单据有两种上级单据,目前只做到了让当前单据PRPay里的Z_DDRQ等于上级单据PRPin里的PayDate,如果当前单据的上级单据是 PUInv,如何引用PUInv中的Pa
如果一定要写,可以这样写:
Update TD
SET TD.Z_DDRQ=IsNull(TM1.PayDate,TM2.PayDate)
from PRPay TM
LEFT JOIN PRPayA TD ON TM.DocEntry=TD.DocEntry
LEFT JOIN PRPin TM1 ON TD.BaseDocNum=TM1.DocEntry
LEFT JOIN PUInv TM2 ON TD.BaseDocNum=TM2.DocEntry