SQLsummary/普通查询/会员奖金余额.sql

SELECT
	SUM( b.BONUS ) AS 会员奖金余额,
	SUM( w.CASH ) AS 会员账户余额,
	SUM( B.RECONSUME_POINTS ) AS 会员复消积分 
FROM
	AR_USER_BONUS b
	LEFT JOIN AR_USER u ON u.ID = b.USER_ID
	LEFT JOIN AR_USER_WALLET w ON w.USER_ID = b.USER_ID 
WHERE
	u.`STATUS` = 1