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 Pjoin tblOrgMonthlyReport M on P.AgencyID = M.AgencyIDjoin tblOrgMonthlyLinkages L on L.MonthlyID = M.MonthlyIDwhere P.CSWGroup = 1order by Agency