www.jinanyonyou.com 济南用友SELECT RdRecord.cCode AS [收发单据号],RdRecord.dDate AS [单据日期],RdRecord.cRdCode AS [收发类别编码],RdRecord.cDepCode AS [部门编码],RdRecords.cInvCode AS [存货编码],Inventory.cInvName as [存货名称],Inventory.cInvStd as [存货规格],RdRecords.iQuantity AS [数量],ComputationUnit.cComUnitName AS [单位],v_mom_moallocate_rpt.Qty AS [标准用量],v_mom_moallocate_rpt.AllocateId AS [生产订单子件用料资料标识Id],v_mom_order_rpt.MoCode AS [生产订单号码],Department.cDepName AS [部门名称]  FROM RdRecord INNER JOIN RdRecords  ON RdRecord.ID = RdRecords.ID INNER JOIN v_mom_moallocate_rpt  ON RdRecords.iMPoIds = v_mom_moallocate_rpt.AllocateId AND RdRecords.cInvCode = v_mom_moallocate_rpt.InvCode INNER JOIN v_mom_orderdetail_rpt  ON v_mom_moallocate_rpt.MoDId = v_mom_orderdetail_rpt.MoDId INNER JOIN v_mom_order_rpt  ON v_mom_orderdetail_rpt.MoId = v_mom_order_rpt.MoId INNER JOIN Department  ON RdRecord.cDepCode = Department.cDepCode   INNER JOIN Inventory  ON RdRecords.cInvCode = Inventory.cInvCode  INNER JOIN ComputationUnit  ON ComputationUnit.cComUnitCode = Inventory.cComUnitCode     where RdRecord.cRdCode='0206'