John Vorhauer

Thank you Vincent for your response. The problem with your proposal is, that you can optimizte it further into SELECT XXXX_Proceeding, but then there ist no link left to the person, that have a role in the proceeding.

Hi there, hope you have some hints on this topic. I have a custom object for proceeding named XXXX_Proceeding. These proceedings are linked to Person and the following OQL statement does what it should: SELECT v, p FROM XXXX_Proceeding AS v JOIN lnkPersonToProceeding AS l ON l.proceeding_id = v.id JOIN Person AS p ON l.person_id = p.id So far, so good. Unfortunately the proceedings not linked to a person are not listed (a LEFT JOIN would do it, if implemented). So I tried different approaches and...