Neo4j cypher query simulate sql join query

Question

I have two different kinds of node entities without any relationships between them, i wonder how to write a cypher query to join these two node entities by common property?

For example, if i want to return a blog by passing blogId as a parameter, but i also want to return creator username by joining user entity. Is it possible? Thanks in advance.

Answer 1

Why don't you have a relationship between user and blog? As far as graph dbs are concerned to connect data, this will help you to get users' blogs. Further, you can connect the blogs according to their topics etc.