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 GROUP BY C.`存货编码` ORDER BY SUM(v.`商品金额`) DESC