Pollutant dict

SELECT 
    PD.id as opt_id,
    PollutantGroup as opt_key,
    pollutant as opt_value,
    pollutant as opt_text
FROM [IED].[DB_VERSION].[PollutantDict] as PD
LEFT JOIN  [IED].[DB_VERSION].[PollutantGroupDict] as PGD
ON PD.PollutantGroupId = PGD.Id
GROUP BY PD.id, pollutant, PollutantGroup
ORDER BY opt_text