Hi,

I have a issue with left outer join without a direct mapping between two tables.
For example if i hv
Table A
Id Code
1 AAA
2 BBB
3 CCC
Table B
Id Label
1 XYZ
3 QWE
4 RTY
And there is no relation between two tables.

The following HQL is inner join by default because of "from A a, B b" as per my understanding.
select a, b from A a, B b where b.id=a.id....

But i want left outer join results i.e the HQL should return all the 3 rows with id's 1,2,3.

Please let me know what is the way out for this.

Thanks,
Sharada.