oracle左连接（用户表，中间表，角色表）的分页查询

select * from (select tt.,rownum as rowno from (select u.,r.rolename,ur.* from tb_system_user u
left join tb_system_user_role ur on u.id = ur.userid
left join tb_system_role r on r.id = ur.roleid ) tt where rownum <=#{start}#{end}) where rowno > (#{start} - 1)#{end}