如采购收货单连接批次表、产品入库连接批次表、销售发货连接批次表。

实例

凭证细表 ：TD
批次表 ：TB，TB1，TB2

SELECT *
FROM WHPin TM
INNER JOIN WHPinA TD ON TM.DocEntry = TD.DocEntry
LEFT JOIN BCIbr TB ON TD.DocEntry = TB.BaseEntry AND TD.ObjType = TB.BaseType AND TD.LineNum = TB.BaseLineNum
LEFT JOIN BCIbtA TB1 ON TB.DocEntry = TB1.BaseEntry
LEFT JOIN BCIbt TB2 ON TB1.StockKey = TB2.StockKey