Hey all, Haven't been around much recently as I've been quite busy with a startup, but I've got a quick SQL question. I've basically got a transactions table in my DB set up in the way you'd probably more or less expect: id, amount, sender_id, recipient_id, and some other fields that are quite irrelevant to the discussion. Is there a good way to calculate an account's total transaction history in one fell swoop? It's easy enough to do two "SELECT sum(amount) as sentTotal FROM transactions WHERE sender_id = X" type of queries and combine the values externally; just wondering if there's a "cleaner" way to do it. Thanks!