Advertisement
Advertisement
| 01.15.2008 at 08:30AM PST, ID: 23084412 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: |
SELECT Office.OffName, SkillLevel.SkDesc, Employee.Emplname, Employee.Empfname, Employee.Empnum, SUM(IIf(WIP.Wbillable=1, WIP.Whours, NULL)) AS BillableHours
FROM Employee INNER JOIN
Office ON Employee.Empoff = Office.OffID INNER JOIN
SkillLevel ON Employee.Emplevel = SkillLevel.SkID RIGHT OUTER JOIN
WIP ON Employee.ID = WIP.WempID
GROUP BY Office.OffName, Employee.Empnum, Employee.Emplname, Employee.Empfname, SkillLevel.SkDesc
ORDER BY Office.OffName, SkillLevel.SkDesc
|