DS_CALC_Procedure/OTHER_SQL/截至至现在店长商场订单.sql

SELECT
	D.`店长会员编号`,
	D.`店长姓名`,
	A.`订单号`,
	A.`商品金额`,
	A.`PV合计`,
	A.`创建时间`
FROM `店长清单` D
	LEFT JOIN
		(SELECT
			V.`会员编号`,
			V.`订单号`,
			SUM(V.`商品金额`) AS 商品金额,
			SUM(V.`PV合计`) AS PV合计,
			V.`创建时间`
		FROM
			zr_product_pkg_vw V
		WHERE
			V.`创建时间` > '2021-02-01 00:00:00' AND V.`订单号` LIKE 'U%'
			GROUP BY V.`订单号`) A ON D.`店长会员编号` = A.`会员编号`