[nhusers] Create a Query as below Using QueryOver or Query

[Abdul Samad]

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.

[Gunnar Liljas]

And how are your classes mapped to these tables?

Post by Abdul Samad
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
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.