Re: left join with sum and group by
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
Subject
Views
Written By
Posted
24059
August 18, 2010 05:46AM
8397
August 20, 2010 11:40PM
Re: left join with sum and group by
4542
August 23, 2010 04:26AM
6632
August 27, 2010 08:01PM
4057
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.