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#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...