I'm giving this thread a little bump and including the SQL here too, so we'll have it. I got back from the accountant today, and I can say that pshabi is right - reporting sessions day by day is the way to go. I'm on my wayu out now - I'll explain more later.
Here is the SQL:
SELECT MONTH(s.session_start) AS SessionMonth, DAY(s.session_start) AS SessionDay, YEAR(s.session_start) AS SessionYear, SUM(amount_won) AS AmountWon
FROM players AS p INNER JOIN [session] AS s ON s.player_id=p.player_id
WHERE p.screen_name='Rogue23' or p.screen_name='TalkingPoker'
GROUP BY MONTH(s.session_start), DAY(s.session_start), YEAR(s.session_start)
ORDER BY YEAR(s.session_start), MONTH(s.session_start), DAY(s.session_start);
The only parts you need to change are the bolded parts above and you can add as many more "or" clauses as you like.
|