为什么要用c?
select a.user_name ,b.timestr,b.kills from user1 a join user_kills b on a.id=b.user_id where b.kills =(select MAX (c.kill)from user_kills c where c.user_id=b.user_id);
其中c是哪个表?为什么要用c?
select a.user_name ,b.timestr,b.kills from user1 a join user_kills b on a.id=b.user_id where b.kills =(select MAX (c.kill)from user_kills c where c.user_id=b.user_id);
其中c是哪个表?为什么要用c?
2016-05-06
举报