Oracle关联查询,多行用一列显示
SELECT paper_id,wmsys.wm_concat(b.kownledge_id) kownledge_ids,wmsys.wm_concat(b.name) name from T_STORAGE_PAPER_DATA a
left join t_storage_classify b on a.kownledge_id like '%'||b.kownledge_id||'%' group by paper_id



SELECT paper_id,wmsys.wm_concat(b.kownledge_id) kownledge_ids,wmsys.wm_concat(b.name) name from T_STORAGE_PAPER_DATA a
left join t_storage_classify b on a.kownledge_id like '%'||b.kownledge_id||'%' group by paper_id


