MySQL query (select statement) question

Yes, SELECT GROUP_CONCAT(Authors.name), … FROM GROUP BY Articles.id

https://dev.mysql.com/doc/refman/5.5/en … oup-concat">https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_group-concat

Thanks Nibbler

Will have to add some more columns, but this is what query looks like for now (and it works):

SELECT a.Title AS Article, 
  GROUP_CONCAT(DISTINCT c.Category ORDER BY c.Category) AS Categories, 
  GROUP_CONCAT(DISTINCT CONCAT(b.FirstName, " ", b.LastName) ORDER BY b.LastName) AS Authors 
FROM Articles AS a 
LEFT JOIN ArticleCategories AS ac ON (a.ArticleID = ac.ArticleID) 
LEFT JOIN Categories AS c ON (ac.CategoryID = c.CategoryID) 
LEFT JOIN ArticleAuthors AS aa ON (a.ArticleID = aa.ArticleID) 
LEFT JOIN Authors AS b ON (aa.AuthorID = b.AuthorID) 
GROUP BY a.ArticleID;