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
No data