Here is the query I have for the tables I need.
--I would not use the where issue_ID in as I need it for all issues. Below is just a subset of the results.
SELECT [Name] as [Issue_Type]
FROM [IMS].[dbo].[CategoryIssues] a
left join [IMS].[dbo].[Categories] b
on a.Category_Id = b.Id
where Issue_Id in (10004516,
Credit Bureau 10004516
Credit Bureau 10005483
I need it to say
Issue ID Issue Type
10004516 Credit Bureau; Collections
10004608 Dealer; Collections