Hi,
What is the syntax for a IN clause with multiple columns?
The following is the classical Sql request that I need to translate as a HQL request:

select * from my_table where (id1, id2) in ( (10,20), (30,40) )

Thx by advance for your reponses.

Francillo

Friend,

query="from Bean as Alias where Alias.csaid in ('U1001','U1002')";

i worked and have pasted here. Hope this wud help u.


regrds,
Jyeshta