Couldn't you also group by grouper2 and date2 ?
Something like:
...
GROUP BY grouper1, grouper2, date2
Just a hint I didn't test it.
On Thu, 2003-10-16 at 01:01, Travis Reeder wrote:
> I am trying to do an aggregate query, but having some problems and here
> they are simplified:
>
> Table
I am trying to do an aggregate query, but having some problems and here
they are simplified:
Table1
date1
grouper1
x
Table2
date2
grouper2
y
Query is something like this:
SELECT SUM(x) as sum_x, SUM(y) as sum_y
FROM Table1
LEFT OUTER JOIN Table2 on grouper2 = grouper1
(date2 >= '2003-07-01 00:00
