Export customer store credit and points from Volusion DB

Question

I came across this necessity lately and there is no explicit query or documentation on how to do this directly.

Answer 1

The solution is this SQL query

SELECT c.CustomerID, c.EmailAddress, SUM(g.GiftAmountLeft) AS 'Store Credit', SUM(rph.points) AS 'Reward Points' 
FROM Customers AS c JOIN GiftCards AS g ON c.CustomerID = g.CustomerID 
JOIN Reward_Points_History AS rph ON c.CustomerID = rph.customerid 
GROUP BY c.CustomerID, c.EmailAddress ORDER BY c.CustomerID

This will export customer ID, e-mail, store credit and reward points.