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

 

 

 

 

posted @ 2017-06-26 15:55  Mr.邹  阅读(461)  评论(0)    收藏  举报