GROUP_CONCAT 拼接顺序

用 group_concat 拼接后的顺序
group_concat(id order by id)
里面id更新需要更换

SELECT zyfl.zyfl_bh,

 GROUP_CONCAT(zybh_pre,zymc order by zydm asc SEPARATOR ';') as zy_list

FROM

 (

SELECT

   z3.bh AS zyfl_bh,
   z3.mc AS zyfl_mc

FROM

   zyfl z1,
   zyfl z2,
   zyfl z3

WHERE

   z1.bh = z2.fbh

AND z2.bh = z3.fbh

AND z1.bh = #{xl_bh}

order by z3.sx asc

 ) AS zyfl

LEFT JOIN (

 SELECT

zy.zymc,

zy.zydm as zydm,

CONCAT(zy.bh,’:’ ) AS zybh_pre,

zy.zyfl_bh

 FROM

zy

order by zydm asc

) zy ON zyfl.zyfl_bh = zy.ZYFL_BH

GROUP BY

 zyfl.ZYFL_BH