>
> select p.Id, p.Description, sum(c.HoursCharged)

from Task e

> left join fetch e.Parent p
> left join fetch e.Children c
> where e.ParentId = :id
> group by p.Id, p.Description
>

sorry i miss the "from task e" line.

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to