AnsweredAssumed Answered

Combine queries

Question asked by mundi on Oct 28, 2013
Latest reply on Oct 28, 2013 by mundi
Hi,

I wonder if there is any way to combine multiple queries.
To be more specific I have to do a search on several custom aspects.
An example for the queries to combine are the following:
select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId

and
select d.cmis:objectId from cmis:document as d join accident:foto as a on d.cmis:objectId = a.cmis:objectId

these two queries give me results. I've tried:
select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId join accident:foto as f on d.cmis:objectId = f.cmis:objectId;

but this won't give me any results.
Then I tried with the union
select d.cmis:objectId from cmis:document as d join accident:reponse as a on d.cmis:objectId = a.cmis:objectId union select d.cmis:objectId from cmis:document as d join accident:foto as a on d.cmis:objectId = a.cmis:objectId

but this returns me the error that the "Union" is unknown.
I'm using opencmis.

Has anyone an idea?

Outcomes