MySQL链表查询Join

MySQL查询操作

三表联合查询Join

select t2.user_login,t2.user_nicename,t2.mobile,t3.name,t3.phone,t1.times,t1.photo_path from
( t1 left join t2 on t1.employee_no= t2.id)
left join t3 on t1.openid=t3.openid
ORDER BY t2.user_login desc;