select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id=b.user_id where (b.user_id,b.kills) in (select user_id ,max(kills)) from user_kills group by user_id;
2015-08-02
举报