I am using the follwoing query
SELECT Fixtures.FixtureID, Fixtures.DateTime, Fixtures.Competition, Fixtures.Opposition, Fixtures.Venue, Fixtures.Attendance, Fixtures.HGoals, Fixtures.AGoals, Fixtures.Pts, Fixtures.Pos, Fixtures.TV, Players.SecondName
FROM Fixtures LEFT JOIN Goals ON Fixtures.FixtureID = Goals.FixtureID LEFT JOIN Players ON Players.PlayerID = Goals.PlayerID
WHERE Fixtures.DateTime > 1028156399 AND Fixtures.DateTime < 1030834800
ORDER BY Fixtures.DateTime ASC
The problem is I want Players.SecondName to display a list of goals scorers in each game but my query returns a seperate row for every goal scored. I have tried using a group by clause with Fixtures.FixtureID but this then only shows the first scorer.
How do I concatenate all the rows returned from Goals into one row?
Sorry if this dosn't make sence
SELECT Fixtures.FixtureID, Fixtures.DateTime, Fixtures.Competition, Fixtures.Opposition, Fixtures.Venue, Fixtures.Attendance, Fixtures.HGoals, Fixtures.AGoals, Fixtures.Pts, Fixtures.Pos, Fixtures.TV, Players.SecondName
FROM Fixtures LEFT JOIN Goals ON Fixtures.FixtureID = Goals.FixtureID LEFT JOIN Players ON Players.PlayerID = Goals.PlayerID
WHERE Fixtures.DateTime > 1028156399 AND Fixtures.DateTime < 1030834800
ORDER BY Fixtures.DateTime ASC
The problem is I want Players.SecondName to display a list of goals scorers in each game but my query returns a seperate row for every goal scored. I have tried using a group by clause with Fixtures.FixtureID but this then only shows the first scorer.
How do I concatenate all the rows returned from Goals into one row?
Sorry if this dosn't make sence