Hi Fellow mates

I have a req in which 2 list's are passed from the front end .

ie List 1 contains ids and List 2 contains some Alpahbets

followings are the Data base records

1000 A
1000 B
1001 A
1001 C


we wants records which has the combinations of (1000,A) and (1001,C)

issue here is if i use IN CLAUSE and pass the list like

from beanname where id in (:idlist) and alpabhet in (alphaberlist)

we will get all the records but we need only records stated below

1000 A
1001 C

please help me how can i write the Hql to solve the issue


Thanks in advance

Sidd