SQLsummary/报表/爱康产品销售额排名.sql

SELECT 
	C.`产品名称`,SUM(V.`数量`) AS 数量,SUM(v.`商品金额`) AS 商品金额,C.`来源` 
FROM 
	zr_product_pkg_vw V LEFT JOIN `产品信息` C ON V.`存货编码` = C.`存货编码` 
WHERE 
	V.`期数` = 161 AND C.`来源` = "爱康" 
	GROUP BY C.`存货编码` 
	ORDER BY SUM(v.`商品金额`) DESC