Hi,
Its better to do the grouping inside the pseudo table query.
ie.
select a,b,c,sum_d
from table1,
(select sum(d) sum_d,e from table2) alias_table2
where c=e (or whatever the condition is)
The simple query looks like the one below,but it 'll take more time to execute as the columns increses...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.