Author: mrabd423

how to return query results as a comma seperated list in mysql

Here is the query SELECT ar.ArtistName, GROUP_CONCAT(al.AlbumName) FROM Artists ar INNER JOIN Albums al ON ar.ArtistId = al.ArtistId GROUP BY ArtistName; +————————+—————————————————————————-+ | ArtistName | GROUP_CONCAT(al.AlbumName) | +————————+—————————————————————————-+ | AC/DC …