I want such query

select t1.a,t2.b from table1 t1,
left join table2 t2 on (t1.id = t2.id)


how do I do that?
a) in hbm.xml file or
b) in hql
c) or in qyertcrietria

Thanks in advance