mysql - 需要以对手的别名而不是逐队返回对手得分

Question

我正在尝试运行一个查询来显示球队得分和对手得分。但是我要在表格中显示什么，以便对手分数区域通过别名“对手”显示。

我无法使用 mysqi 解决这个问题，有人建议我需要创建一个函数来传递结果。我没有编写函数的经验，并且我尝试研究如何编写函数，但没有成功。

我的查询

SELECT CONCAT(RoundNo, ',',Season) AS Game, Team, Total 
FROM MatchDetails  
WHERE Team = 'Team A' 
AND Season = 2015 
UNION
SELECT CONCAT(RoundNo, ',',Season) AS Game, Opponent, OTotal 
FROM MatchDetails  
WHERE Team = 'Team A'
AND Season = 2015

我当前的结果集

Game| Team  | Total
1 |Team A   | 125
2 |Team A   | 80
3 |Team A   | 78
4 |Team A   | 89
5 |Team A   | 102
1 |Team B   | 100
2 |Team C   | 79
3 |Team D   | 85
4 |Team E   | 87
5 |Team F   | 45

我想要的结果集

Game| Team  | Total
1 |Team A   | 125
2 |Team A   | 80
3 |Team A   | 78
4 |Team A   | 89
5 |Team A   | 102
1 |Opponent | 100
2 |Opponent | 79
3 |Opponent | 85
4 |Opponent | 87
5 |Opponent | 45

Answer 1

这是你想要的吗？

SELECT CONCAT(RoundNo, ',', Season) AS Game, Team, Total 
FROM MatchDetails  
WHERE Team = 'Team A' AND Season = 2015 
UNION ALL
SELECT CONCAT(RoundNo, ',', Season) AS Game, 'Opponent', OTotal 
FROM MatchDetails  
WHERE Team = 'Team A' AND Season = 2015;

区别在于对手周围的引号。