![]() |
#20
|
||||
|
||||
![]()
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. |
|
|