[jboss-user] [EJB 3.0] - how to write query for in select

john_woo@canada.com do-not-reply at jboss.com
Thu Jul 26 20:30:56 EDT 2007


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?



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4068057#4068057

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4068057

More information about the jboss-user mailing list