Attach to each row of entity the rows of joinEntity its join reaches, through the on clauses in order.
Each clause narrows both its records to the rows that match the other side: first the rows of the left one that
match a right one, then the right ones that match those (see semiJoin for the order). A row's join starts from the
row alone and from the rows read for every other record (see joinBases), so each record is read once for the whole
join and each lookup is built once, rather than every loaded row being copied for each row joined.
Parameters
entity: any
joinEntity: any
dataSets: {} = {}
joinClauses: any[] = []
entityAlreadyResolved: boolean = false
Whether the where clause already narrowed entity's rows (then they aren't read again:
an empty list reads as "not loaded yet", see readEntity).
Attach to each row of
entitythe rows ofjoinEntityits join reaches, through theonclauses in order.Each clause narrows both its records to the rows that match the other side: first the rows of the left one that match a right one, then the right ones that match those (see semiJoin for the order). A row's join starts from the row alone and from the rows read for every other record (see joinBases), so each record is read once for the whole join and each lookup is built once, rather than every loaded row being copied for each row joined.