Oracle Multi-Table query

Oracle Multi-Table Query 1 put multiple data into one field

Select Id,zhzxm,fzhzxm,ltrim (Max (Sys_connect_by_path (XM, ', ')), ', ') XM
From (
Select Id,zhzxm,fzhzxm,xm,row_number () over (partition by ID ORDER by LRSJ) RN--mark the same field
From
(select T2.id id,t2.zhzxm zhzxm,t2.fzhzxm fzhzxm, T1.xm xm,t1.lrsj lrsj from T_yj_yjzhy T1 left joins T_YJ_YJZHZXX T2 on T1 . Yjzhzid = t2.id)
)
Start with Rn=1
Connect by prior rn=rn-1 and prior Id=id
GROUP BY ID,ZHZXM,FZHZXM

Oracle Multi-Table query