Re: [Hibernate] Problem With query in Hibernate

2003-09-29 Thread William R. Lorenz
Laurent, With regards to the LEFT JOIN clauses, I've always used mapped Set objects (many-to-one,one-to-many) and then interated the resulting Java Set object to return only the objects that I need. I'm sure there's a more efficient way to do this though, and I'd love to hear what you find out

[Hibernate] Problem With query in Hibernate

2003-09-29 Thread Laurent Fleuriot
  Hi,   I would like to have the query Hibernate of this query sql :   select document.pbl_id from pbl_version_doc documentleft join reponse on reponse.VPr_ID = document.VPr_IDleft join reponse_pbl_sit on (reponse_pbl_sit.rps_id = reponse.rps_id  and reponse_pbl_sit.vst_id <> '472a03cb4971e3