I have a aggregate total based on transaction type...
SELECT transType AS trxType, SUM(amount) AS totSum FROM payments
WHERE result = 0
GROUP BY trxType
This will bring back results such as...
How do I get a subquery of the SUM amount that will further separate the e.g. Payment $1000 further into... $200 American Express, $700 Visa, $100 MasterCard for example.
Thank you for your assistance.