SELECT RdRecord.cCode AS [出库单号],RdRecord.dDate AS [出库日期],RdRecord.cVouchType AS [单据类型编码], RdRecords.cInvCode AS [存货编码],RdRecords.iQuantity AS [出库单数量],RdRecords.iUnitCost AS [出库单单价], RdRecords.iPrice AS [出库单金额],Inventory.cInvName AS [存货名称],Inventory.cInvStd AS [规格型号], ComputationUnit.cComUnitName AS [单位],Warehouse.cWhName AS [仓库名称],Customer.cCusAbbName AS [客户简称], SO_SOMain.cSOCode AS [销售订单号], SO_SOMain.dDate AS [销售订单日期],SO_SOMain.cexch_name AS [币种名称],SO_SOMain.iExchRate AS [汇率], SO_SODetails.iQuantity AS [销售订单数量],SO_SODetails.iUnitPrice AS [原币无税单价], SO_SODetails.iTaxUnitPrice AS [原币含税单价],SO_SODetails.iMoney AS [原币无税金额], SO_SODetails.iSum AS [原币价税合计],SO_SODetails.iNatUnitPrice AS [本币无税单价], SO_SODetails.iNatMoney AS [本币无税金额],SO_SODetails.iNatSum AS [本币价税合计],SO_SODetails.iTaxRate AS [税率], DispatchList.cDLCode AS [发货单号],DispatchList.dDate AS [发货单日期] FROM RdRecord INNER JOIN RdRecords ON RdRecord.ID = RdRecords.ID INNER JOIN Inventory ON RdRecords.cInvCode = Inventory.cInvCode INNER JOIN ComputationUnit ON Inventory.cComUnitCode = ComputationUnit.cComunitCode INNER JOIN Warehouse ON RdRecord.cWhCode = Warehouse.cWhCode INNER JOIN Customer ON RdRecord.cCusCode = Customer.cCusCode INNER JOIN DispatchLists ON RdRecords.iDLsID = DispatchLists.AutoID INNER JOIN DispatchList ON DispatchList.DLID = DispatchLists.DLID left JOIN SO_SODetails on SO_SODetails.iSOsID=DispatchLists.iSOsID left JOIN SO_SOmain ON SO_SOMain.ID = SO_SODetails.ID WHERE RdRecord.cVouchType=32