Multiple results from an SQL query

Multiple results from an SQL query

I am not 100% sure how to phrase this question. I searched through the
archives as much as I could but could not find what I was looking for.
I have three database tables.
tblSeason(Id,Season)
tblPlayers(ID,FirstName,LastName,DisplayName,Handicap,Current)
tblMatch(ID,MatchDate,Season,Player1,Player2,Player1Score,Player2Score,Winner)
I have been trying to work out how to return something like the following.
Player1
Player2 -- 2 Games Against
Player3 -- 1 Game Against
Player2
Player1 -- 2 Games Against
Player3 -- 3 Games Against
Thanks