二表相连生成新数据，用group by未成功，有难度。
二表通过type相连，
在mysql下，很易实现，但oracle中，不会。
谢谢大家，祝好人二生平安。
[解决办法]
不就是连接两个表吗？
说清楚你的需求。
[解决办法]
select a.type id,a.name type,wmsys.wm_concat（b.desc）descs from table1 a left join table2 b on a.type=b.type group by id
[解决办法]
上面已经已经有答案了..
WITH A AS(
SELECT 1 AS TYPE,'NAME1' AS NAME,1 AS ID,'WC1' AS DES FROM DUAL UNION ALL
SELECT 2,'NAME2',2,'WC2' FROM DUAL UNION ALL
SELECT 3,'NAME3',3,'WC3' FROM DUAL UNION ALL
SELECT 4,'NAME4',4,'WC4' FROM DUAL
),B AS(
SELECT 1 AS ID,1 AS TYPE,'WC1' AS DES FROM DUAL UNION ALL
SELECT 2,2,'WC2' FROM DUAL UNION ALL
SELECT 3,2,'WC3' FROM DUAL UNION ALL
SELECT 4,4,'WC4' FROM DUAL
)
SELECT A.ID, A.NAME, WMSYS.WM_CONCAT(B.DES)
FROM A, B
WHERE A.TYPE = B.TYPE(+)
GROUP BY A.ID, A.NAME;
WITH A AS(
SELECT 1 AS TYPE,'NAME1' AS NAME,1 AS ID,'WC1' AS DES FROM DUAL UNION ALL
SELECT 2,'NAME2',2,'WC2' FROM DUAL UNION ALL
SELECT 3,'NAME3',3,'WC3' FROM DUAL UNION ALL
SELECT 4,'NAME4',4,'WC4' FROM DUAL
),B AS(
SELECT 1 AS ID,1 AS TYPE,'WC1' AS DES FROM DUAL UNION ALL
SELECT 2,2,'WC2' FROM DUAL UNION ALL
SELECT 3,2,'WC3' FROM DUAL UNION ALL
SELECT 4,4,'WC4' FROM DUAL
)
SELECT ID,NAME,LTRIM(MAX(SYS_CONNECT_BY_PATH(DES, ',')), ',') AS DES FROM
(
SELECT ROW_NUMBER() OVER(PARTITION BY A.ID ORDER BY NAME) R,A.ID,A.NAME,B.DES
FROM A, B
WHERE A.TYPE = B.TYPE(+)
)
START WITH R = 1
CONNECT BY PRIOR R=R-1
AND PRIOR ID =ID
GROUP BY ID,NAME
ORDER BY 1
where a.type(+)=b.type
group by b.name;
