SELECT DispatchList.cDLCode AS [发货退货单号],DispatchList.dDate AS [单据日期],DispatchList.cDepCode AS [部门编码],DispatchList.cPersonCode AS [业务员编码],DispatchList.cCusCode AS [客户编码],DispatchList.cCusName AS [客户名称],DispatchLists.cWhCode AS [仓库编码],DispatchLists.cInvCode AS [存货编码],DispatchLists.cInvName AS [存货名称],DispatchLists.iQuantity AS [发货数量],DispatchLists.iSettleQuantity AS [累计开票数量],RdRecords.iQuantity AS [出库数量],RdRecord.cCode AS [出库单号],RdRecord.dDate AS [出库日期]  FROM DispatchList INNER JOIN DispatchLists  ON DispatchList.DLID = DispatchLists.DLID INNER JOIN RdRecords  ON DispatchLists.AutoID = RdRecords.iDLsID INNER JOIN RdRecord  ON RdRecords.ID = RdRecord.ID