Hi All,


I am having two table like A and B. A is having x as its primary key and also having a foreign key relationship using x with the table B. table B is having one more column as y which manages a parent relationship with x.
I am writing my sql query like this.
Select something from A a left outer join B b on b.y = a.x

I am new to this technology, please suggest me a way using hql with mapping file to do this.

Thanks In Advance,
Gopal