I have a column that contains multiple values (unfortunately). These values are numeric ids. They point back to a lookup table that contains the actual text string. I have a SQL query that has this:
SELECT first_name, last_name, subjects
INNER JOIN etc
The subjects come back as (2,5,83,65). I don't want to return them like that. I want to return them with the string names. There is a table that stores the string names called "Subjects" but I'm unsure how to write the query so
the string values come back in that one column.
Any help appreciated
View Complete Post