17,140
社区成员




select
max(case when c.role_id=1 then a.user_name end) 增加,
max(case when c.role_id=2 then a.user_name end) 删除,
max(case when c.role_id=3 then a.user_name end) 修改
from
[user] a,role_use b,role c
where a.user_id=b.user_id and b.role_id=c.role_id
select case when role_name = '增加' then user_name end as "增加",
case when role_name = '修改' then user_name end as "修改",
case when role_name = '删除' then user_name end as "删除"
from (select user_name, role_name
from role_tab a, role_user b, user_tab c
where a.role_id = b.role_id
and c.user_id = b.user_id);