select_get_userroles.sql

一套宾馆管理系统

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'