Hi All, I wanted to generate a query as below.
Select EMP.EmployeeName, EMP.NoOfReportees, D.DepartmentName from (Select E.EmployeeName, COUNT(R.ReportingEmployeeID) FROM Employees E JOIN Reportees R ON E.EmployeeID = R.managerID GROUP BY E.EmployeeName) EMP JOIN Department D ON EMP.DepartmentID = D.DepartmentID Please let me know How can I use queryover to generate this above query. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
