17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> select * from a;
/*
ITEMID TYPEID TYPENAME
--------------------------------------- --------------------------------------- ----------
1 2 bbb
2 3 ccc
2 5 ddd
3 5 ddd
1 1 aaa
*/
SQL> select * from b;
/*
ITEMID ITEMNAME
--------------------------------------- ----------
1 kkk
2 lll
3 ooo
*/
SQL> select a.itemid,b.itemname,wmsys.wm_concat(a.typename)
2 from a,b
3 where a.itemid=b.itemid
4 group by a.itemid,b.itemname;
/*
ITEMID ITEMNAME WMSYS.WM_CONCAT(A.TYPENAME)
--------------------------------------- ---------- --------------------------------------------------------------------------------
1 kkk bbb,aaa
2 lll ccc,ddd
3 ooo ddd
*/