SELECT FinancialTransactions.UserID, Sum(FinancialTransactions.TotalAmount) AS Account FROM FinancialTransactions INNER JOIN FinancialSessions ON FinancialTransactions.SessionID = FinancialSessions.ID WHERE FinancialSessions.Active=True GROUP BY FinancialTransactions.UserID, FinancialSessions.Active, FinancialTransactions.SessionID ORDER BY FinancialTransactions.SessionID DESC