SQLQuery5.sql

/**---- select * from KuChun select * from Sell select sum(SellNum)as Sumd,SellID,ProductType from Sell group by SellID,ProductType select * from KuChun t1 left join (select SellID, sum(sellnum)as snum,ProductType from Sell group by SellID,ProductType)t2 on t1.ShopID=t2.SellID and t1.Pro