IN expression for multiple columns in HQL

dazzwater · **Posted:** Wed Jan 14, 2009 2:22 am

On Oracle, I am able to execute the following query:

Code:

select * from test where (col1,col2) in ((1,2),(2,3),(3,4),(4,5))

I have a Java collection which is the result of a HQL query (select col1,col2 from another_table). Is there any way for me to include this collection in a HQL query to perform the above?

I'm thinking of a query along the lines of:

Code:

from testEntity where (col1,col2) in (:coll)