Mysql 实现篮球比赛赛程中两支队伍的查询

表结构如下：

查询两支队伍的比赛情况，sql语句如下：

SELECT t1.team_name,g.team1_score,g.team2_score,t2.team_name,g.gametime FROM game as g,team as t1 ,team as t2 WHERE g.team1_id = t1.team_id AND g.team2_id = t2.team_id

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/pilihaotian/p/8823193.html