For MSSQL:


SELECT serd.Name AS "Service Category",
rtl.Templatename AS "Template Name",
catres.title as "Resource Section",
( 
SELECT STUFF(( SELECT ','+ ca.aliasname from ColumnAliases ca 
left join resource_question req_ques1 on ca.columnaliasesid=req_ques1.questionid
left join catalogresource catres1 on req_ques1.catresid=catres1.uid
left join resourcetemplatemapping rtm1 on catres1.uid=rtm1.resourceid
left join requesttemplate_list rtl1 on rtm1.templateid=rtl1.templateid
WHERE rtl1.templateid = rtl2.templateid and catres1.uid = catres2.uid FOR XML PATH('') ),1,1,'') 
FROM RequestTemplate_List rtl2
LEFT JOIN ResourceTemplateMapping rtm2 ON  rtm2.TEMPLATEID=rtl2.TEMPLATEID
LEFT JOIN CatalogResource catres2 on rtm2.resourceid = catres2.uid
where rtl2.templateid = rtl.templateid and catres2.uid = catres.uid ) as "Resource Question" FROM RequestTemplate_List rtl
LEFT JOIN ServiceDefinition serd ON rtl.PARENT_SERVICE=serd.SERVICEID
LEFT JOIN ResourceTemplateMapping rtm on rtl.TEMPLATEID = rtm.TEMPLATEID
LEFT JOIN CatalogResource catres on rtm.resourceid = catres.uid
where catres.title is not null
group by serd.name, rtl.Templatename, rtl.templateid,catres.title,catres.uid
ORDER BY 1;

For PGSQL:


SELECT serd.name AS "Service Category",
    rtl.templatename AS "Template Name",
    catres.title AS "Resource Section",
    (
        SELECT array_to_string(array_agg(ca.aliasname), ',') FROM ColumnAliases ca
LEFT JOIN resource_question req_ques1 ON ca.columnaliasesid = req_ques1.questionid
LEFT JOIN catalogresource catres1 ON req_ques1.catresid = catres1.uid
LEFT JOIN resourcetemplatemapping rtm1 ON catres1.uid = rtm1.resourceid
LEFT JOIN requesttemplate_list rtl1 ON rtm1.templateid = rtl1.templateid
WHERE rtl1.templateid = rtl.templateid AND catres1.uid = catres.uid
    ) AS "Resource Question" FROM requesttemplate_list rtl
LEFT JOIN ServiceDefinition serd ON rtl.parent_service = serd.serviceid
LEFT JOIN resourcetemplatemapping rtm ON rtl.templateid = rtm.templateid
LEFT JOIN catalogresource catres ON rtm.resourceid = catres.uid
WHERE catres.title IS NOT NULL
GROUP BY serd.name, rtl.templatename, rtl.templateid, catres.title, catres.uid
ORDER BY 1;