Other Habitats - Species

select * from (select distinct
his.habitat_unique_id,
his.scientific_name,
species_group_common_name,
id_eunis,
relationship_code,
relationship_description
from EUNIS.latest.Habitat_Indicator_Species his, EUNIS.latest.Habitat_Information hi
where hi.habitat_unique_id = his.habitat_unique_id
and upper(hi.habitat_description) like '%' + upper(his.scientific_name) + '%'
and relationship_code = 'mentioned'
) a
order by relationship_code asc