M.Jones M.Jones - 1 year ago 61
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

Answer Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download