select_get_userroles.sql

来自「一套宾馆管理系统」· SQL 代码 · 共 8 行

select b.roleid,b.rolename 
 from userroles a 
 left outer join rolelist b
 on a.roleid=b.roleid
 left outer join userlist c
 on a.userid=c.userid
 where c.username='admin'