I'd like to retrieve a list of objects that contain objects from two entities without using inheritance. The list would be an outer join between the two entities. Consider [Entity, Automapping] TEmployee = class private FId: Integer; FName: string; public property Id: Integer read FId write F…

For clarity, I want to create in Aurelius the equivalent of the following: select a.id, a.Name, b.TerminationDate from Employee a left join TerminatedEmployee b on a.Id = b.employee; I'd also like to do select id, Name from Employee where id not in (select id from TerminatedEmployee)

After I made the post, I considered the solution you recommended. Thanks.

Create an outer join between entities

BIZ TMS Aurelius

wlandgraf (Wagner Landgraf) August 4, 2026, 10:44am 3

I assume you have an unique key in TerminatedEmployee that makes sure Employee_ID column there is unique, so you have a 1:1 mapping.

In this case I suggest you use this approach for 1:1 mapping: