Hello, need help to return multiple rows into 1 singular column with semicolon delimiter. I tried the FOR XML PATH but got stuck because my original query requires a nested join. Below is an example of the current results and my expected results. Thanks in advance!
select a.WorkflowID, b.ResourceName
from table1 a
left join (select distinct ResourceID, ResourceName
where ResourceType = 4) b on a.ConstructID = b.ResourceID
where a.ConstructType = 4