Hi! Can someone help me ? I'm trying to make a LEFT JOIN QUERY, but the query return duplicate result. Its possible make a DISTINCT or GROUPBY ? Why the query return the JOIN values to ? The result dont need to show me only F.cmis:objectId as ID, ...

Scenario: 1 - Create two Files. 2 - Create a Note. 3 - Create a Relation using File and Note. 4 - Want Return all files in a LEFT JOIN Query with Notes. SELECT F.* FROM File F LEFT JOIN Relation R ON R.cmis:sourceId = F.cmis:objectId Expected: All ...