展开全部
|
Mysql 下的执行结果:32313133353236313431303231363533e58685e5aeb931333335333035create table r(r_id int);
create table u(u_id int, u_name varchar(8));
create table ru(r_id int, u_id int);
insert into r values(1);
insert into r values(2);
insert into u values(1, '1');
insert into u values(2, '2');
insert into u values(3, '3');
insert into ru values(1,1);
insert into ru values(1,2);
insert into ru values(1,3);
select
r.r_id, GROUP_CONCAT(u.u_name) as all_u_name
from
ru right join r on ( ru.r_id = r.r_id )
left join u on ( ru.u_id = u.u_id )
group by
r.r_id
;
+------+------------+
| r_id | all_u_name |
+------+------------+
| 1 | 1,2,3 |
| 2 | NULL |
+------+------------+
2 rows in set (0.00 sec)