create table wlbtest1( username varchar2(2), deptID number ); create table wlbtest2( deptName varchar2(10), deptID number ); insert into wlbtest1 values ('a', 1); insert into wlbtest1 values ('b', 1); insert into wlbtest1 values ('c', 1); insert into wlbtest1 values ('d', 2); insert into wlbtest1 values ('e', 2); insert into wlbtest1 values ('f', 2); insert into wlbtest2 values ( '部门1' ,1); insert into wlbtest2 values ( '部门2', 2); select deptID, wm_concat(username) username,'部门'||deptID deptName from wlbtest1 group by deptID