group by 能否拼接两条查询记录？

select Prod_CL as Prod_ID,b.Prod_Name as Prod_Name,b.Prod_Price as Price,Coll_Quantity as Quantity,(b.Prod_Price*Coll_Quantity) as Total
from tb_Order_Collocate a,tb_Product b
where Orde_ID = 10000 and a.Prod_CL = b.Prod_ID and Prod_CP in (select a.Prod_ID from tb_OrdersInfo a,tb_Product b where Orde_ID = 10000 and Ty_ID = 104 and a.Prod_ID = b.Prod_ID)
union all
select a.Prod_ID as Prod_ID,a.Prod_Name as Prod_Name,OrIn_Price as Price,OrIn_Quantity as Quantity,Orde_Total as Total
from tb_OrdersInfo a,tb_Product b
where Orde_ID = 10000 and Ty_ID = 102 and a.Prod_ID = b.Prod_ID
非常感谢 呵呵 ！接分！

group by语句显示记录条数问题 sql查询 group by SQL group by 问题 mssql group by 问题 SQL GROUP BY 问题 请教group by ,谢谢!!!!!! SQL中的GROUP BY sql中关于group by sql Group by 的使用 sql group by 报错