SELECT v_mom_order_rpt.MoCode AS [生产订单号码],v_mom_orderdetail_rpt.SortSeq AS [行号],    v_mom_order_rpt.CreateDate AS [日期],    mom_morder.StartDate AS [开工日期],mom_morder.DueDate AS [完工日期]  ,v_mom_orderdetail_rpt.InvCode AS [物料编码],      Inventory.cInvAddCode AS [存货代码],Inventory.cInvName AS [存货名称],    Inventory.cInvStd AS [规格型号],  v_mom_orderdetail_rpt.Qty AS [生产订单数量],    v_mom_orderdetail_rpt.QualifiedInQty AS [入库数量],v_mom_orderdetail_rpt.Status AS [状态],      v_mom_orderdetail_rpt.MDeptCode AS [生产部门],Department.cDepName AS [部门名称],v_mom_modetail.Remark  AS [生产线别]       FROM v_mom_order_rpt INNER JOIN v_mom_orderdetail_rpt    ON v_mom_order_rpt.MoId = v_mom_orderdetail_rpt.MoId       left JOIN Department  ON v_mom_orderdetail_rpt.MDeptCode = Department.cDepCode       INNER JOIN Inventory  ON v_mom_orderdetail_rpt.InvCode = Inventory.cInvCode      INNER JOIN mom_morder  ON v_mom_orderdetail_rpt.MoDId = mom_morder.MoDId     INNER JOIN     v_mom_modetail    ON   v_mom_order_rpt.MoCode=v_mom_modetail.MoCode   where v_mom_orderdetail_rpt.modid  in (select v_mom_moallocate_rpt.modid from v_mom_moallocate_rpt where v_mom_moallocate_rpt.IssQty>0) 济南用友，济南用友软件www.jinanyonyou.com