Dear all,
The two tables employee and customer have not explicate association (by FK and PK). In Oracle SQL, we can use the operator (+) as follows for an outer join. For example,

SELECT *
FROM employee, customer
where employee.name = customer.name(+)


However, HQL does not support this outer join operator. How can we translate the above SQL select to HQL?
Regards.
Pengyou [quote][/quote]

You can try this

from employee e right outer join e.customer

This solution can not work in my case for the following reason:

The table employee has not explicte association with customer (I meant there is no employee.customerId = customer.id defined) so right outer join will gives the exception : org.hibernate.hql.ast.QuerySyntaxException: Path expected for join!