sql語句合並

[guoluguolu]

1__alter table T_StoreJIT add Userquantity as (Quantity-IP+onloadquantity)
2__select MaterielCode ,max(Attribute) as Attribute, sum(Quantity) as Quantity
,max(IP) as IP,max(WP) as WP,max(OnloadQuantity) as onloadquantity ,CreationTime
from T_StoreJIT group by MaterielCode ,CreationTime order by CreationTime desc
----怎樣把語句1,2兩條SQL語句合並乘一條sql語句
----2中間還有很多字段我沒寫出來了
-------謝謝了！！