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.