I need help with this query

[vigour]

This query gives me all distinct municipality sorted in ascending order. Exactly like I want.

SELECT DISTINCT municipality FROM archive JOIN municipality ON municipality.municipality_id = archive.municipality_id ORDER BY municipality ASC

But I also want municipality_id. How should I change the query to get both municipality_id and municipality?

[OldDogNewTricks]

How about:

SELECT DISTINCT archive.municipality_id as id, municipality FROM archive JOIN municipality ON municipality.municipality_id = archive.municipality_id ORDER BY municipality ASC