合并两个查询结果集。在线等

[zhangzhen_927116]

select b1.deep,b1.FrProName,SUM(b1.Qty)qty,sum(b1.TtlArea)ttlarea,sum(b1.TtlGirth)ttlgirth,sum(b1.TtlWeight)ttlweight
from v_PrdWIPTran  as b1 where b1.approval='Y' and b1.trandate>=@BEGIN_TIME and b1.trandate<=@END_TIME
and b1.type !='TK' GROUP BY b1.FrProName,b1.deep,b1.frMacName  ORDER BY b1.frMacName desc

select b1.deep,b1.FrProName,SUM(b1.Qty)qty,sum(b1.TtlArea)ttlarea,sum(b1.TtlGirth)ttlgirth,sum(b1.TtlWeight)ttlweight
from v_PrdWIPTran  as b1 where b1.approval='Y' and b1.trandate>=@BEGIN_TIME and b1.trandate<=@END_TIME
and b1.type ='BP' GROUP BY b1.FrProName,b1.deep,b1.frMacName  ORDER BY b1.frMacName desc

怎么把这两个查询结果合并到一起。
如下

结果1
A   B    C
1    2    3
结果2
A    B    C
1     2    1
合并成
A     B     C     结果2C
1      2     3         1 

[霜寒月冷]

你是写在存储过程里面的语句把，不如建两张临时表，把语句插入进去，然后 tb1 join tb2 一下，当然这个方法简单粗暴。