多表 MySQL 查询 [英] Multiple tables MySQL query
本文介绍了多表 MySQL 查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
继续上一个问题,我需要在查询不起作用的下方显示分数
In continuation with previous question, I need to display score below query does not work
问题在这里:问题 1
INSERT INTO TblScore (ScoreID, TeamID, MatchID, Score) VALUES
(1, 1, 1, 5),
(2, 2, 1, 6),
(3, 4, 2, 15),
(4, 3, 2, 26);
分数查询不起作用
$query="SELECT
m.MatchID,
m.MatchDate,
m.Team1ID,
m.Team2ID,
s.TeamID,
s.MatchID,
T1.TeamName as TeamName1,
T2.TeamName as TeamName2,
T1S.Score as Team1Score,
T2S.Score as Team2Score
FROM TblMatch m
JOIN TblTeam T1 ON m.Team1ID = T1.TeamID
JOIN TblTeam T2 ON m.Team2ID = T2.TeamID
JOIN TblScore s ON m.Team1ID = T1S.TeamID
JOIN TblScore s ON m.Team1ID = T1S.TeamID
JOIN TblScore s ON m.Team2ID = T2S.TeamID
WHERE s.MatchID=$mid
";
推荐答案
可以吗?
$query="SELECT
m.MatchID,
m.MatchDate,
m.Team1ID,
m.Team2ID,
s.TeamID,
s.MatchID,
T1.TeamName as TeamName1,
T2.TeamName as TeamName2,
s.Score as Team1Score,
s2.Score as Team2Score
FROM TblMatch m
JOIN TblTeam T1 ON m.Team1ID = T1.TeamID
JOIN TblTeam T2 ON m.Team2ID = T2.TeamID
JOIN TblScore s ON m.Team1ID = s.TeamID AND m.MatchID = s.MatchID
JOIN TblScore s2 ON m.Team2ID = s2.TeamID AND m.MatchID = s2.MatchID
WHERE s.MatchID=$mid";
这篇关于多表 MySQL 查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文