Hi there

Just a complete beginner question. I'm trying to replace some Oracle specific joins in my SQL to make them work with hibernate / postgres and am having some real problems when it comes to joins.

What I'm trying to do is create a query which has multiple outer joins, the code looks like this from my oracle version

select * from a,b
where a.code = b.code (+)
and a.location = b.location (+)
and a.key = b.key (+)

What I've tried is something like this
select *
from a.code right outer join b.code
and a.location right outer join b.location
and a.key right outer join b.key

CAn anyone spot if I'm doing something totally wrong? Please help!

that SQL is being created in my Java code

Well you are using an alias "a" which is not defined anywhere.

http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html

Sorry about that, just added that code in at the last minute so it would read better. We do have a defined alright as select * from table1 a, like that.