I have to entities, Movie and Genre, with a many-to-many-relation. Movie name genres
Genre name movies This query works for ONE genre: select distinct m from Movie m left join m.genres as g where g.name = :genreName How should I write EJB-QL for "find movies by genres" with JBoss 4.0.4RC1? Regards Peter View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3924741#3924741 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3924741 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
