odbtools/odbctest/mql/uino/500.多关系类型查询.mql

 MATCH (staff:/mingdao1/staff WHERE attr0 = 'UN0067')
 -[:is_duty_sales_of_contract|is_member_sales_of_contract|is_pm_of_contract|is_presales_of_contract|is_sales_of_contract*1..1]->
 (contract:/mingdao1/contract)
 -[:is_contract_of_project*1..1]->
 (project:/mingdao1/project) 
 RETURN contract.attr2 AS "contract_id", contract.attr1 AS "contract_name", project.attr0 AS "project_id", project.attr3 AS "project_name", project.attr66 AS "total_amount"
/**
output()
**/
 ;

 MATCH (staff:/mingdao1/staff WHERE attr0 = 'UN0067')
 -[:is_duty_sales_of_contract|is_member_sales_of_contract|is_pm_of_contract|is_presales_of_contract|is_sales_of_contract*1..1]->
 (contract:/mingdao1/contract)
 -[:is_contract_of_project*1..1]->
 (project:/mingdao1/project) 
 RETURN contract.attr2 AS "contract_id", contract.attr1 AS "contract_name", project.attr0 AS "project_id", project.attr3 AS "project_name", project.attr66 AS "total_amount"
 INTO aaaaaa;
 ;

 SELECT temp.contract_id AS "合同编号", temp.contract_name AS "合同名称", temp.project_id AS "项目ID", temp.project_name AS "项目名称", temp.total_amount AS "项目总金额(元)" FROM aaaaaa temp 
 LIMIT 0, 10
 /**
 output()
 **/
;

 SELECT temp.contract_id AS "合同编号", temp.contract_name AS "合同名称", temp.project_id AS "项目ID", temp.project_name AS "项目名称", temp.total_amount AS "项目总金额(元)" FROM aaaaaa temp 
 ORDER BY total_amount DESC LIMIT 0, 10
;