Hi, sorry, I forgot to write.
It was: select title, 'Roles' from role where id in | (select roles_id from cmtuser_role where cmtuser_id in | (select id from cmtuser where username = ?)) | for my db-structure. Thank you very very much for your hint; it was very important for me to find the solution. :-) Thanks. NSchweig View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4242021#4242021 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4242021 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
