M.Jones M.Jones - 7 months ago 13
SQL Question

Selecting more than one value

Trying to generate a list of tracks composed by more than one person.

Name Composer Make

So it should look something like this

Name composer Make
Going home Robert dennings / Don Bedge Robert dennings , Don Bedge


You probably want something like this

SELECT Name, Composer, REPLACE(Composer,'/',',') AS Make
FROM tracks

But it really is impossible to tell for sure given that you don't tell us any of the table or field names in your database and very little about your database model