This looks a little complicated, but it works:
open table "my_table"
select my_field, count(*)
from my_table
into new_table
where my_field in (select my_field from my_table group by my_field)
group by my_field
order by my_field (if desired)
browse * from my_table
using the city_125 table that comes as part of the MapInfo tutorial, this looks like:
select state, count(*) from city_125 into new_table where state in (select state from city_125 group by state) group by state order by state
browse * from new_table
At 01:01 AM 08/24/2000, you wrote:
Hey guys,
Here is an easy one for you - I have a field of site numbers - which unfortunatley are not unique. What I would like to do is querry this field and produce a second table that contains a list of each site number occurence. I am very new to SQL, but I think that this should be a simple query!!
Thanks in advance, Chris
David L. Dennis
SOFPREP Support Manager Phone: (904) 881-2312
TYBRIN Corporation DSN: 641-2312
[EMAIL PROTECTED] FAX: (904) 881-4985
