Mysql 实现篮球比赛赛程中两支队伍的查询时间:2023-03-10 07:18:56 表结构如下: 查询两支队伍的比赛情况,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