I believe the answer to how to do it in Hibernat 3 cam be found here: http://www.javalobby.org/articles/hibernate-query-101/ Speficially, look under the "More advanced techniques" heading! Good luck.