[eclipselink-users] OUTER JOIN to Secondary Table

[Andrei Shakirin <andrei.shakirin@xxxxxxxxx>]

Hello,

 

Is it any way in EclipseLink to make OUTER JOIN to Secondary Table?

Use case: There is a main employee table that may or may not have some extra data populated in a related secondary table. If there is data in the secondary table (@SecondaryTable), then I would like my Employee entity to have those fields filled in. If there isn't data for a given employee in the secondary table, then I would like my Employee entity to have nulls in those fields. Right now, if there's no row in the secondary table for a given employee, I get nothing.

Unfortunately I cannot find acceptable solution in Internet.
Is INNER JOIN for Secondary Table fixed by design?

Regards,
Andrei.