Hi,if table a (int av, varchar(10) an), table b (int bv, varchar(10) bn),I wantselect 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?ThanksJohn