index on field1 unique to temp.idx
then copy to an other table
or
select table1.field1 from table1 distinct into table table2
/Kjell

>How can I summarize a table like this
>
>
> USA
> USA
> USA
> USA
> BRAZIL
> BRAZIL
> BRAZIL
> UK
> UK
> UK
> UK
> UK
> CANADA
> CANADA
>
> ......Etc. Over 2000 names
>
>
> To a new summarized table
>
> USA
> BRAZIL
> UK
> CANADA
> ..........ETC