Use LEFT JOIN between two table in HQL

Question

I have two POJO classes. One is EmployeeTO and another one is AddressTO.

EmployeeTO has one variable with name EmployeeId and AddressTO also has one variable with name EmployeeId. I want to apply a left join between EmployeeTO's EmployeeId and AddressTO's EmployeeId using HQL.

I used the following query.

from EmployeeTO employeeTO LEFT JOIN AddressTO addressTO ON employeeTO .EmployeeId=addressTO.EmployeeId

But it shows an error:

line 1:139: unexpected token: ON

@MaciejKowalski No But EmployeeTO Table contains all EmployeeID whereas AddressTO table contains some EmployeeID which also present into the EmployeeTO — Vishal Mittal, Jan 05 '18 at 12:28

score 4 · Answer 1 · answered Jan 05 '18 at 12:16

4

There is no ON clause in an HQL join:

from EmployeeTO e
left join e.addressTO

This assumes that your Employee entity class has an AddressTO field called addressTO.

answered Jan 05 '18 at 12:16

Tim Biegeleisen

502,043
27
286
360

in e.addressTO addressTO's a will be in lower case? – Vishal Mittal Jan 05 '18 at 12:22
@VishalMittal All the names should match the underlying entities. – Tim Biegeleisen Jan 05 '18 at 12:59

Use LEFT JOIN between two table in HQL

1 Answers1