搞定了.select a.预定id,a.产品编号,a.部品品番,a.客户品番,a.客户名称, a.是否下单,a.部品个数,a.部品总数,sum(b.订购数量) as 订购数量,c.交货日期 from composing a left outer join (select 预定id,产品编号,部品品番,sum(订购数量) as 订购数量 from pu_o group by 预定id,产品编号,部品品番) b on ((a.预定id=b.预定id) AND (a.产品编号=b.产品编号) and (a.部品品番=b.部品品番)) join destine c on a.预定id=c.id AND a.产品编号=c.产品编号 where b.订购数量 is null or a.部品总数-订购数量>0 group by a.预定id,a.产品编号,a.部品品番,a.客户品番,a.客户名称, a.是否下单,a.部品个数,a.部品总数 ,c.交货日期
a.是否下单,a.部品个数,a.部品总数,sum(b.订购数量) as 订购数量,c.交货日期
from composing a left outer join (select 预定id,产品编号,部品品番,sum(订购数量) as 订购数量 from pu_o group by 预定id,产品编号,部品品番) b
on ((a.预定id=b.预定id) AND (a.产品编号=b.产品编号) and (a.部品品番=b.部品品番)) join destine c
on a.预定id=c.id AND a.产品编号=c.产品编号
where b.订购数量 is null or a.部品总数-订购数量>0
group by a.预定id,a.产品编号,a.部品品番,a.客户品番,a.客户名称,
a.是否下单,a.部品个数,a.部品总数 ,c.交货日期