I have a query where I get the results from a Join. However, what I would like to achieve is combining all the multiple results into one row for each unique Agency. Please see the attached file. How can I adjust the code to achieve the desired results.
Here is the query that I am using:
select P.Agency,M.Month,L.LinkageName,L.Linkage from tblOrgProfile P
join tblOrgMonthlyReport M on P.AgencyID = M.AgencyID
join tblOrgMonthlyLinkages L on L.MonthlyID = M.MonthlyID
where P.CSWGroup = 1
order by Agency
Results and Desired Results in the attachment