cypher编写

请教下,如果是cypher转成sql语句,有方向的关系,应该怎么join呢,请教下各位老师,
比如这个语句:
match (m:USER {mobileId: ‘01bfd6de1a494e131daee6319707de7b9783ee128250f41df896d8f2a3fef10e’})
OPTIONAL (MATCH (m)-[r1:CALL_TO]-(x:MOBILE)-[:APPLY_FOR]->(a1:APPL))
return count(a1)

转换后的sql语句
create table xy_temp.graph_APPLY_FOR_APPL_ON_TIME_tmp1
select
a.*,
b.src as b_src,
b.dst as b_dst,
c.id as c_id,
c.label2 as c_label2,
d.id as d_id,
e.id as e_id
from xy_temp.graph_USER_CALL_TO_MOBILE_tmp1 a
join (select * from xy_temp.graph_online_v2_edges where label=‘APPLY_FOR’) b
join (select * from xy_temp.graph_online_v2_vertices_split where label2 = ‘APPL’) c
join (select * from xy_temp.graph_online_v2_edges where label=‘APPLY_ON’) d
join (select * from xy_temp.graph_online_v2_vertices_split where label2 = ‘TIME’) e
on a.src = b.src and b.dst = c.id and c.id = d.src and d.dst = e.id
and a.first_callmark_on < ‘20220401’ and a.last_callmark_on > ‘20190401’ and e.date < ‘2022-04-01’

有方向的关系,是怎么join的呢

此话题已在最后回复的 30 天后被自动关闭。不再允许新回复。