select kg.*, kgunit.ms_time from tb_kg kg left join tb_kg_unit kgunit on kg.kg_id = kgunit.kg_id
where kg.kg_biaozhi = '否' order by kg.kgrole asc, kg.kg_id asc;
两表联合查询查到如下结果,将 kg_name相同的 ms_time合并到一个字段,该如何操作?
想要的效果图如下:
需要将语句改成
select kg_id,kgrole,kg_name, wm_concat(to_char(ms_time)) from (select kg.*, kgunit.ms_time from tb_kg kg left join tb_kg_unit kgunit
on kg.kg_id = kgunit.kg_id where kg.kg_biaozhi = '否') group by kg_id,kgrole,kg_name;
*函数wm_concat 出现乱码时需要加 to_char()
以下为不加tochar的结果