select  PO_Pomain.cPOID AS [订单号],PO_Pomain.cVenCode AS [供应商编码],  Inventory .cInvCCode AS [存货分类编码],InventoryClass .cInvCName AS [存货分类名称], PO_Podetails.cInvCode AS [存货编码],  Inventory.cInvStd AS [规格型号],Inventory.cComUnitCode AS [主计量单位编码],ComputationUnit.cComUnitName AS [单位],  PO_Podetails.iQuantity [数量],PO_Podetails.iReceivedQTY AS [累计入库数量],PO_Podetails.dArriveDate AS [计划到货日期],  PO_Pomain.dPODate AS [日期],PO_Pomain.cVerifier AS [审核人],PO_Podetails.cbCloser AS [行关闭人]  FROM PO_Pomain INNER JOIN PO_Podetails  ON PO_Podetails.POID = PO_Pomain.POID  INNER JOIN Inventory  ON PO_Podetails.cInvCode =Inventory.cInvCode  INNER JOIN ComputationUnit  ON ComputationUnit.cComUnitCode = Inventory.cComUnitCode  LEFT JOIN InventoryClass   ON  Inventory.cInvCCode = InventoryClass .cInvCCode