since ejbql works only on entities, there is no way you can do this in QL.
maybe it works with the <declared-sql> override in jboss-cmp-jdbc.
else you will have to use a view instead of your table, or build the other entity as well
in jboss.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4027073#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...