Hello friends,
I need your help with the following.

I have the following tables

Table A (a1, a2, ab) - a1 is the key, ab is foriegn jkey for table B
Table B (b1, b2, ab) - ab is the key

Table C(c1, c2, c3)

I want to use hiberate to come up with a query like this

select A.a1, A.a2, A.ab
from A, B
where A.ab = B.ab(+)
and B.b1 = :param1
and A.a2 in (select distinct c2 from C)

I have already created POJO's for all the tables
A object has List of B's and C object is seperate POJO.



I started out using Hibernate Query..but couldn't get to make it work.
But any approach is fine with me.

Any help is greatly appreciated.