I am trying to map the following query:

select c.col3
from table1 a, table2 c

where (a.col1_id = c.col2) and c.col3 in (select col3 from table2
where col2=51)

Below are my table defenitions
Table 1
col1 - PK

Table 2
col2- FK
col3

The above query works with Oracle. Can somebody suggest how to map it with HQL

thanks
BD

Try this:


If that doesn't work, you can take the long route...two seperate queries...i.e. doing your inner query first, getting the list from it, and creating a StringBuffer of the elements. But, the above should work.
I added in the ":value", so that you can re-use the query for different col3 values. :)

Try reading through the HQL section of the Hibernate_Reference.pdf file, I go there often.

-G