odbtools/odbctest/mql/uino/070.match.mql

-- MATCH (grpcont:/aia/grpcont WHERE grpcontno = 'G09***956C')-[:grpcont_risk*1..1]->(risk:/aia/risk), 
-- (grpcont)-[:grpcont_plan*1..1]->(plan:/aia/plan), 
-- (plan:/aia/plan)-[:plan_risk*1..1]->(risk:/aia/risk) 
-- /**
-- output()
-- **/
-- ;


MATCH (grpcont:/aia/grpcont WHERE grpcontno = 'G09***956C')-[:grpcont_risk*1..1]->(risk:/aia/risk), 
(grpcont)-[:grpcont_plan*1..1]->(plan:/aia/plan), 
(plan:/aia/plan)-[:plan_risk*1..1]->(risk:/aia/risk) 
RETURN
grpcont.id, plan.id, risk.id
-- grpcont.grpcontno AS "grpcontno", grpcont.grppropno AS "grppropno", grpcont.grpname AS "grpname", 
-- grpcont.grpcity AS "grpcity", risk.riskcode AS "riskcode", risk.riskname AS "riskname", 
-- risk.risktype AS "risktype", risk.terminationdate AS "terminationdate", grpcont.polprem AS "polprem", 
-- grpcont.anpvalue AS "anpvalue", grpcont.anpvaluenovat AS "anpvaluenovat", plan.plancode AS "plancode", 
-- plan.plandesc AS "plandesc", plan.plansumprem AS "plansumprem"
WITH TIMEOUT = 600m
/**
output()
**/
;