join


Related Questions
  0 votes
  1 answers
  1 comments
  846 views

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, ...
  0 votes
  1 answers
  4 comments
  1340 views

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 ...
  1 votes
  1 answers
  1 comments
  979 views