Query Results as List

OUTER APPLY( SELECT Inspectors = STUFF((
  SELECT DISTINCT ',' + ISNULL([GA_FNAME], '') + CASE
   WHEN ISNULL([GA_MNAME], '') = ''
   THEN ' '
   ELSE ' ' + [GA_MNAME] + ' '
   END + ISNULL([GA_LNAME], '')
  FROM G6ACTION
  WHERE B1PERMIT.SERV_PROV_CODE = G6ACTION.SERV_PROV_CODE
 AND B1PERMIT.B1_PER_ID1 = G6ACTION.B1_PER_ID1
 AND B1PERMIT.B1_PER_ID2 = G6ACTION.B1_PER_ID2
 AND B1PERMIT.B1_PER_ID3 = G6ACTION.B1_PER_ID3
  FOR XML PATH('')),1,1,'')
) AS B1