简单数据库连表查询（2）

select operateid,truename,Headportrait,rolename,userid from role inner join(
      select truename,Headportrait,operateid,d.roleid,d.userid from roleoperate c inner join(
            select roleid,truename,Headportrait,a.userid from userrole a inner join(
            select id,truename,Headportrait from usertable 
            	where username='user' and password='e10adc3949ba59abbe56e057f20f883e')b 
            	on a.userid=b.id)d 
            on d.roleid=c.roleid
       )e on e.roleid=id

从user的账号以及密码来进行获取角色名
思路是从最里面的那层开始看，对应的是第一步从usertable开始查找