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!
Thanks, Laurent. On Mon, 29 Sep 2003, Laurent Fleuriot wrote: > 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 -- _ __ __ ___ _| | William R. Lorenz <[EMAIL PROTECTED]> \ V V / '_| | http://www.clevelandlug.net/ ; "Every revolution was \./\./|_| |_| first a thought in one man's mind." - Ralph Waldo Emerson ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
