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;
MySQL查询MySQL查询操作三表联合查询JoinMySQL查询操作三表联合查询Joinselect 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.openidORDER BY t2.user_login desc;...