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#4068057 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4068057 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user