Hi

I have a table with several names of cities

I want to use "select" to create a new table or cursor with contains
a field with the city name and other field with the quantities of cities


as below

CITY ===== QUANT.
SAO PAULO= 10
RIO ======= 5
BOGOTA==== 3

etc


From this cursor want to create a chart (if possible)

Thanks

Moises