Hi, ist it possible to rewrite the following SQL snippet with the LLBL Gen objects? I couldn't find a possibility to add an AND/predicate to the LEFT OUTER JOIN/JoinHint

SELECt SA.str_Bezeichnung, SA2M.lngFK_berechtigung, SA2M.lngFK_Partner
FROM tbl_subapplikation SA
LEFT outer JOIN tbl_subappl2mitarbeiter SA2M
ON SA.lngPK_Subapplikation = SA2M.lngFK_Subapplikation 
AND SA2M.lngFK_Partner = 2704
WHERE SA.lngFK_Datei = 80

Thanks in advance!

I think IEntityRelation.CustomFilter should allow this, though I've never used it.

Thanks for your answer! Yes, this is what i've been looking for.