select tbr_id ,wm_concat(t.zz_name) as zzName from Gp_Gcjs_Tbr_Zz t group by tbr_id
下面做的一个例子,东西有点多。
select rownum as xh, ts.*
from (select t1.id,
t2.id as licenseId,
t3.org_pers_id as persId,
t1.local_code as loaclCode,
t1.local_name as localName,
t1.agc_cn_name as agcCnName,
t1.bi_reg_addr as biRegAddr,
t1.local_name as yydz,
t3.pers_name as faren,
t3.link_phone as frPhone,
t3.mobile as frTelePhone,
t1.contact_people as contactPeople,
t1.contact_phone as contactPhone,
t1.phone_num as contactTelePhone,
t2.rank as rank,
decode(t2.rank, 1, '甲级', '0', '乙级', '') as rankName,