17,382
社区成员




select a.eid,wm_concat(a.beid) beid,b.bid from a left join b on a.beid=b.beid group by a.eid,b.bid;
with t as (
select 201 eid, 1 beid,1 bid from dual union all
select 201 eid, 2 beid,4 bid from dual union all
select 201 eid, 5 beid,4 bid from dual union all
select 201 eid, 6 beid,4 bid from dual union all
select 201 eid, 3 beid,15 bid from dual union all
select 201 eid, 4 beid,28 bid from dual union all
select 202 eid, 10 beid, 1 bid from dual union all
select 202 eid, 11 beid, 1 bid from dual union all
select 202 eid, 12 beid, 15 bid from dual
)select eid,wm_concat(beid),bid from t
group by t.eid,t.bid
1 201 1 1
2 201 2,6,5 4
3 201 3 15
4 201 4 28
5 202 10,11 1
6 202 12 15
CREATE TABLE T42
(
eid NUMBER(4),
bedi NUMBER(4)
);
INSERT INTO T42 VALUES(201, 1);
INSERT INTO T42 VALUES(201, 2);
INSERT INTO T42 VALUES(201, 3);
INSERT INTO T42 VALUES(201, 4);
INSERT INTO T42 VALUES(201, 5);
INSERT INTO T42 VALUES(201, 6);
INSERT INTO T42 VALUES(202, 10);
INSERT INTO T42 VALUES(202, 11);
INSERT INTO T42 VALUES(202, 12);
CREATE TABLE T43
(
beid NUMBER(4),
bid NUMBER(4)
);
INSERT INTO T43 VALUES(1, 1);
INSERT INTO T43 VALUES(2, 4);
INSERT INTO T43 VALUES(5, 4);
INSERT INTO T43 VALUES(6, 4);
INSERT INTO T43 VALUES(3, 15);
INSERT INTO T43 VALUES(4, 28);
INSERT INTO T43 VALUES(10, 1);
INSERT INTO T43 VALUES(11, 1);
INSERT INTO T43 VALUES(12, 15);