I m trying to union/ combine 2 query results with different relationship types that should stay separate afterwards (sub queries r2, r3 not the same column names). I want to get an output graph with c, p, r2, r3.
I tried the following cypher query:
MATCH (p:Sample)-[r3:`Age`]->(c:Sample)
WHERE
r3.age >= 50
RETURN p, r3, c
UNION
MATCH (p:Sample)-[r1:`Age`]->(c:Sample)
MATCH (p:Sample)-[r2:`Size`]->(c:Sample)
WHERE
(r2.size <= 50 and r1.age >= 20)
return p, r2, c
The error message is of course:
Neo.ClientError.Statement.SyntaxError: All sub queries in an UNION must have the same column names (line 5, column 1 (offset: 98))
"UNION "
The result should look like this table:
p | r2 | r3 | c
___________________________________
p1 | | sth | c1
p1 | sth | | c1
...| ... | ... | ...