如暂收送检单连接采购收货单、发货拣配单连接销售发货单、销售对账单连接应收发票、产品送检单连接产品入库单等。

实例

中间表 ：TD
目标凭证细表 ：TD1

SELECT *
FROM PUTmp TM
INNER JOIN PUTmpA TD ON TD.DocEntry = TM.DocEntry
LEFT JOIN PURevF TD1 ON TD.ObjType = TD1.BaseType AND TD.DocEntry = TD1.BaseEntry AND TD.LineNum = TD1.BaseLineNum
LEFT JOIN PURevA TD2 ON TD1.DocEntry = TD2.DocEntry AND TD1.LineNum = TD2.LineNum