Howdy all!

I've got a join question that I can't seem to be able to figure out.
I have two tables, both O/R mapped. There is no mapping relation between them. Now I want to do a (left) join between them but I can't figure out how.
In SQL it would be 'select * from table1 left join table2 on table1.id = table2.id where table1.id = <something>'.

All the examples I've seen implies that there already is a mapping between table1 and table2. Is this correct? Must there be a mapping between table1 and table2?

I've tried various permutatins of HQL without success.
Right now I'll take any suggestion.

cheers
Erik

You need to use native SQL, or map the relationship and use HQL

OK, thanks for the answer.

cheers
/Erik