we were moving DAO's to hibernate ...
the SQL query which we were using previously is

select slc.firstName, slc.lastName, slc.status, slc.email,
d.state, slc.contactID from <table1> slc,
<tableD> d
where slc.addressID *= d.addressID and slc.status = 'Active' order by slc.lastName, slc.firstName

could any body plz tell me how to write the same in Hibernate?
and what to change in hibernate mapping file? etc...

Thanks in Advance,
vamshi

Your SQL is not an outer join, its just a plain inner join.

Write your Hibernate mappings in such a way you have a one-to-one (or) many-to-one mapping between "table1" and "tableD". When you write a HQL that links the table to its collection item, the SQL will be a joined one between the two tables.
Refer to
http://www.hibernate.org/hib_docs/v3/re ... yhql-joins