Group A Fixtures for October

Jun    Jul    Aug    Sep   

SELECT f.FixtureID, f.Hometeam as HometeamID, th.TName as Hometeam, f.Homescore, f.Awayteam as AwayteamID, ta.TName as Awayteam,f.Awayscore,f.Fixturedate,f.GroupID, f.notes, f.Late FROM 2019sumfixtures f LEFT JOIN 2019sumteams th ON f.Hometeam=th.TeamID LEFT JOIN 2019sumteams ta ON f.Awayteam=ta.TeamID where f.Fixturedate between '2019-10-01' and '2019-10-31' and f.GroupID='1' order by f.Fixturedate,f.Fixtureid;