主题：select语句分组统计问题

表A、表B分别分组统计，然后再连接两表。

如果代码不会写，单独做个例子发上来测试。

1、三个表分别分别分组统计；

2、三个表分别左连接和右连接，最后Union起来即可。

1、分组左连接

select * from (select 货品名称, sum(货品数量) as 订单数 from {订单表} group by 货品名称) as a
 left join
(select 推单型号, sum(推单数量) as 处理数 from {订单处理表} group by 推单型号) as b on a.货品名称=b.推单型号

2、分组右连接

select * from (select 货品名称, sum(货品数量) as 订单数 from {订单表} group by 货品名称) as a
 right join
(select 推单型号, sum(推单数量) as 处理数 from {订单处理表} group by 推单型号) as b on a.货品名称=b.推单型号

3、组合

select * from (select 货品名称, sum(货品数量) as 订单数 from {订单表} group by 货品名称) as a
 left join
(select 推单型号, sum(推单数量) as 处理数 from {订单处理表} group by 推单型号) as b on a.货品名称=b.推单型号
 Union

select * from (select 货品名称, sum(货品数量) as 订单数 from {订单表} group by 货品名称) as a
 right join
(select 推单型号, sum(推单数量) as 处理数 from {订单处理表} group by 推单型号) as b on a.货品名称=b.推单型号