查询每个用户最新的访问日志信息及用户名
(1)
SELECT * FROM tb_user_log t1 WHERE TIME1=(SELECT MAX(TIME1) FROM tb_user_log t2 WHERE t1.userId=t2.userId)
查询出每个用户访问的最新的日志信息:
(2)查询用户信息及最新的日志信息
SELECT u.userName,t2.keywords,t2.time1 FROM tb_user u LEFT JOIN( SELECT * FROM tb_user_log t1 WHERE TIME1=(SELECT MAX(TIME1) FROM tb_user_log t2 WHERE t1.userId=t2.userId)) t2 ON u.id=t2.userId