odbtools/odbctest/mql/basic/17xbase.select/113subquery.mql

match (a:"cypher:e1")-[:connect]->(b:"cypher2:e2") with fields="day,vtime" return a.id as aid, a.name as aname , b.id as bid, b.name as bname
/**
output()
**/
;

select * from
(
    match (a:"cypher:e1")-[:connect]->(b:"cypher2:e2") with fields="day,vtime" return a.id as aid, a.name as aname , b.id as bid, b.name as bname
)
/**
output()
**/
;