SELECT
  CS.ClientID,
  CS.FinNumber,
  CS.GroupName,
  SM.ProductCategory AS Products,
  SM.LabourNetBranch AS Regions
FROM
  taClients AS CS
    LEFT JOIN taClientSummary SM ON (SM.ClientID = CS.ClientID)
WHERE
  (CS.ClientStatus = 1)
ORDER BY
  CS.GroupName