select productid,productCount=(select sum(productCount) from life_unite_order_product where productid=t.productid )from life_unite_order_product as t group by productid order by productid desc
视图ViewProductCommunityName
Name 产品名称
IsShow 产品状态
Productnum 产品数量
Signname 小区名称
Flag 定单状态
ProductId 产品ID
Sign 小区ID
Provider 供货商ID
解决团购订单页 左侧调出用到的 sql语句
select ProductId,Name,Sign,sum(Productnum) as pronum,Signname from ViewProductCommunityName where IsShow<>2 and Flag=1 and Provider=1 group by Name,Sign,ProductId,Signname order by pronum desc
解决团购首页 右上角调出用到的 sql语句
select ProductId,Name,Sign,sum(Productnum) as pronum,Signname from ViewProductCommunityName where IsShow<>2 and Flag=1 group by Name,Sign,ProductId,Signname order by pronum desc