The following is a simplification of what I want to do:

> It is for my ham radio logging program
> which you can freely download from my website
> www(dot)wa0h(dot)com
> the 0 in wa0h is the number zero.

I have a very large database which contains 1 table.

Each record in the table contains 3 fields .. city, population, state.

I want a query that produces the following 50 records:

Alabama, city
Arkansas, city
Arizona, city
etc.

ie .. one (large) city (population > 10,000) for each of the 50 states.

If a state has more than 1 large city, I don’t care which city is picked.

The following SQL statement seems logical, but it does not work.

SELECT DISTINCT city, state
FROM table
WHERE population > 10000

Thanks for your time.

[email protected]