I created an index on the crime_id type. I found the solution, when reversing line 3 to give:
WHERE o.crime_id = i.crime_id
It seems to work and has created the relationships.
Hi Cobra,
I have a similar problem. I have nodes for 'incident' and nodes for 'outcomes', I created an index on a property type 'crime_id' on both the incidents and outcomes. I now need to link the incident node and outcome node. Both share crime_id ...
