[jboss-user] [EJB 3.0] - how to write query for in select
Hi,
if table a (int av, varchar(10) an),
table b (int bv, varchar(10) bn),
I want
select count(*) from a a where av in (select bv from b b where a.an = b.vn)
how to convert it into EJB QL using entityManager.createQuery?
Thanks
John
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4068057#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...