1、多表连接查询去重复问题:可以加个group by id;如:
<!--获取分页数据-->
select * from user u left join userrole ur on u.id=ur.uid left join role r on r.rid=ur.rid
where 1=1
group by u.id
limit 0,7
</select>
2、多表连接查询求count总数:
select count(*) from
(select u.id from user u left join userrole ur on u.id=ur.uid left join role r on r.rid=ur.rid
group by u.id) as a
同理,这里group by u.id是去重复的,而as a是为这个内表查询取别名,虽然没有用处,但是去掉会报错。