Hibernate version:
Hibernate 3.0

Hi,

i am trying to join 2 tables with an outer join.
i need all transactions for given criteria from table1, but values in table2 are optional (object for table2 can be null)

there are multiple columns in which i am trying to join. they can be defined as a primary key for table2, but they are not keys for table1. there should only be 1 row or null returned for each row in table1.

any suggestions for what kind of mapping setup to use? point to any examples? i was reading about some new features in hibernate 3 that might support this type of functionality.

thanks
fidster

a many to one shoud be OK