MySQL Forums
Forum List  »  Optimizer & Parser

Re: left join with sum and group by
Posted by: Andreas Schmidt
Date: August 23, 2010 04:26AM

Very interessting approach, Rick! Thank you for that.

Now I get all the records I expected including those where no activities exists.

But the sum of b.hours looks like a total of the whole month, not just the day.
I'm wondering about that, because the group by is for a.date AND e.employee.

Any idea?

regards
Andreas

Options: ReplyQuote


Subject
Views
Written By
Posted
24000
August 18, 2010 05:46AM
8384
August 20, 2010 11:40PM
Re: left join with sum and group by
4528
August 23, 2010 04:26AM
6619
August 27, 2010 08:01PM
4042
September 07, 2010 05:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.