sql查询表丢失的问题

Question

SELECT match_info.oid,SUM(match_info.bo) as bo,player.team_id,team.`name` as team_name,SUM(match_info.`kill`) as k
from team as t
join player as p
join match_info as m
on match_info.player_id = player.id and player.team_id = team.id
GROUP BY match_info.team_id
ORDER BY k DESC
LIMIT 3;

请问大家串代码哪里出错了，为什么会报出[Err] 1054 - Unknown column 'match_info.oid' in 'field list'错误
表如下

Answer 1

引用 皆我百晓生 小程序回复内容作答：
根据提供的SQL查询语句，报错信息表明在SELECT语句中出现了“match_info.oid”列，但是数据库中没有这个列，导致了错误。您可以检查一下match_info表中是否确实存在oid列，或者将SELECT语句中的match_info.oid列改成数据库中存在的列名来修正该错误。