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

Thursday, 26 July 2007

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...

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

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