How to return all nodes and relationships from a set of nodes?

[sbaskin]

Given a set of nodes, I want to return all relationships within that set without leaving out any nodes that do not have a relationship in that set.

I have no problem getting all nodes that have a relationship within that set, however, I cannot also include nodes that do not have a relationship within the set.

[ameyasoft]

Hi,

Use OPTIONAL MATCH to get the other nodes. Here is a sample query:

MATCH (a:Actor)-->(m:Movie)-->(d:Director)-->(t:Theater)
OPTIONAL MATCH(b:Actor)
RETURN a, m, d, t, b;

Result:

-Kamal

[andrew_bowman]

You can use apoc.algo.cover(nodeList) YIELD rel to get all the relationships between a list of nodes.