Hibernate version: 2.1
Name and version of the database you are using: sql server 2000
Hello, good afternoon. I have a working query written in SQL, and I was wondering how to do something alike with HQL.
Code:
SELECT Recrut
FROM dbo.tVagas v
LEFT OUTER JOIN(
SELECT IDvaga, COUNT(DataEnvio) AS Recrut, COUNT(DataEncaminhamento) AS Encam
FROM dbo.tEncaminhamentos enc
GROUP BY IDvaga
) enc ON v.IDvaga = enc.IDvaga
ORDER BY v.IDvaga
Vaga( IDvaga ) 1..* Encaminhamentos( ID, IDvaga )
I tried to make something like this
Code:
SELECT count( enc.DataEnvio ), ...
FROM Vaga v
LEFT OUTER JOIN v.encaminhamentos enc
But them I would have to "order by" every property besides the "count(..)" (about 15).
Thanks for reading.
Login
FAQ
Search