phranque
msg:4418818 | 3:35 pm on Feb 17, 2012 (gmt 0) |
i would expect you would get a row (the sum of) for each aggregation (each group)
|
skoff
msg:4418824 | 3:39 pm on Feb 17, 2012 (gmt 0) |
yep thats right! but it gives me the error.. dont know how to work around..
|
phranque
msg:4418853 | 4:50 pm on Feb 17, 2012 (gmt 0) |
why is the GROUP BY clause in the subquery?
|
skoff
msg:4418937 | 8:14 pm on Feb 17, 2012 (gmt 0) |
because i want the votes only for this date to be shown
|
arms
msg:4419249 | 3:45 am on Feb 19, 2012 (gmt 0) |
the GROUP BY clause in the subquery is totally irrelevant and doesn't affect days but would create multiple rows in votes on a certain day were in more than 1 clan
Also the "SELECT *," at the beginning would give you a problem ub ab aggregate query!
|
|
