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.ResourceNamefrom table1 aleft join (select distinct ResourceID, ResourceName from table2 where ResourceType = 4) b on a.ConstructID = b.ResourceIDwhere a.ConstructType = 4