Oracle multi-Table query

Oracle multi-Table query

Oracle multi-Table query: one-to-many data is placed in one field.

Select id, zhzxm, fzhzxm, ltrim (max (sys_connect_by_path (xm, ','), ',') xmfrom (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 join between t2 on t1.yjzhzid = t2.id) start with rn = 1 connect by prior rn = rn-1 and prior id = idgroup by id, zhzxm, fzhzxm