[Hibernate] Problem With query in Hibernate

[Laurent Fleuriot]

 

Hi,

 

I would like to have the query Hibernate of this query sql :

 

select document.pbl_id from pbl_version_doc document
left join reponse on reponse.VPr_ID = document.VPr_ID
left join reponse_pbl_sit on (reponse_pbl_sit.rps_id = reponse.rps_id  and reponse_pbl_sit.vst_id <> '472a03cb4971e3c0a8d5a')
where document.etd_id = '3'

 

I think that hibernate can't use a query as this but if a super good man can find the query, I draw my hat to him.

And the problem is I can't use subquery because I use Mysql.

 

thanks