Is there any way to join tables that do not have a specific mapping defined? Here is a simple example:

select Header, Detail from Header as Header join Detail as Detail on Header.detailId = Detail.id

When I try this I get "outer or full join must be followed by path expression". The join notation should be much more efficient than:

select Header, Detail from Header as Header, Detail as Detail where Header.detailId = Detail.id

This last query does work.

Thanks,

David Morris

Use a where clause join ("theta style").

That was the conclusion I came to. I haven't worked through every case where I may need this but I may hit a left join. For Oracle, with the old style (+) syntax it wouldn't be too bad but for DB2 it will be quite a bit slower. I may have to fall back to iBatis for this.

For this very rare case, just use createSQLQuery()