Hi

I have a table which contains towns and municipalities in Spain.

I want users to select a distinct geonameid which corresponds to a town or municipality.

If the municipality asciiname is the same as a town name, i just want the municipality.

This query is incorrect as it returns both the town and municipalities.

select distinct geonameid, asciiname from geo_import where (feature_code = 'ADM3' OR feature_code = 'PPL') AND province_id = '2509951' order by asciiname asc