[GitHub] [age] AbdulSamad4068 commented on issue #820: Are multiple cypher calls possible within the same FROM clause?

["AbdulSamad4068 (via GitHub)" <gi...@apache.org>]

AbdulSamad4068 commented on issue #820:
URL: https://github.com/apache/age/issues/820#issuecomment-1544522955

   If you need to execute multiple Cypher queries and combine their results, you can execute them separately and then combine the results using other SQL operations, such as JOIN, UNION, or subqueries. For example:
   ```
   SELECT *
   FROM (
     SELECT *
     FROM cypher('query1')
   ) AS result1
   JOIN (
     SELECT *
     FROM cypher('query2')
   ) AS result2 ON <join_condition>
   ```
   Replace `<join_condition>` with the appropriate conditions based on your data model
   for example you can write `result1.column_name = result2.column_name`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org