(
select wmsys.wm_concat(distinct xx04.bj) ---wmsys.wm_concat(distinct 字段名)
from kw0406 b
left join kw0407 on kw0407.kw0406id =b.id
left join xx04 on xx04.xx04id = kw0407.bjbh
where b.id = a.id
) as bjmc,
(
select wmsys.wm_concat(distinct xx04.bj) ---wmsys.wm_concat(distinct 字段名)
from kw0406 b
left join kw0407 on kw0407.kw0406id =b.id
left join xx04 on xx04.xx04id = kw0407.bjbh
where b.id = a.id
) as bjmc,