select OM_MOMain.cCode AS [订单号],OM_MOMain.cVenCode AS [供应商名称],  Inventory.cInvCCode AS [存货分类编码],InventoryClass.cInvCName AS [存货分类名称],  OM_MODetails.cInvCode AS [存货编码],Inventory.cInvStd AS [规格型号],Inventory.cComUnitCode AS [主计量单位编码],  ComputationUnit.cComUnitName AS [单位],OM_MODetails.iQuantity AS [委外数量],  OM_MODetails.dStartDate AS [计划下达日期],OM_MODetails.dArriveDate AS [计划到货日期],OM_MODetails.iArrQTY AS [累计入库数量],  OM_MODetails.cbCloser AS [行关闭人]  FROM OM_MOMain INNER JOIN OM_MODetails  ON OM_MODetails.MOID = OM_MOMain.MOID   INNER JOIN Inventory  ON OM_MODetails.cInvCode =Inventory.cInvCode  INNER JOIN ComputationUnit  ON ComputationUnit.cComUnitCode = Inventory.cComUnitCode  LEFT JOIN InventoryClass   ON  Inventory.cInvCCode = InventoryClass.cInvCCode