这样也能查询出来,这种方式可行吗?
SELECT a.user_name,max(u.kills),u.timestr
FROM user_kills as u INNER JOIN user1 as a
ON u.user_id=a.id
GROUP BY u.user_id
SELECT a.user_name,max(u.kills),u.timestr
FROM user_kills as u INNER JOIN user1 as a
ON u.user_id=a.id
GROUP BY u.user_id
2019-07-15
举报