视图 两表联合 查询 id 求和需求

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