Return only distinct combinations of 2 field values
I'm searching on cities and returning city and province, some cities exist in different provinces, which is ok.
However, I have some duplicates, meaning 2 cities occur in the same province. In that case I only want to return 1 result.
I therefore need to have a distinct and unique city+province combination.
How can I make sure that only unique city+province combinations are returned by my query?