Natura 2000 habitats table

select 
    a.code_2000,
    a.scientific_name,
    b.habitat_description,
    a.habitat_prioriy,
    a.habitat_category,
    a.number_countries,
    a.number_sites,
	a.habitat_unique_id
from BISE.latest.Habitat_Information a, EUNIS.latest.Habitat_Information b
where b.habitat_unique_id = a.habitat_unique_id
order by scientific_name