0 Replies Latest reply on Jul 26, 2007 8:30 PM by John Woo

    how to write query for in select

    John Woo Newbie


      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?