解决Access的sql语句join两次出错的问题

其实Access里面是可以join多次的,只是写法方面有些不同罢了.下边是我写的例子.

CodeSELECT p.Id, p.Player, sum(iif(p.Id = m.Winner,s.WinnerScore,s.LoserScore)) AS AmountFROM ([Match] AS m INNER JOIN Score AS s ON m.MatchNumber = s.MatchNumber) INNER JOIN Player AS p ON p.Id = m.Winner or p.Id = m.LoserWHERE m.MatchNumber = 3GROUP BY p.Id, p.PlayerORDER BY sum(iif(p.Id = m.Winner,s.WinnerScore,s.LoserScore)) DESC;

 

转载于:https://www.cnblogs.com/KenBlove/archive/2008/10/16/1312782.html