Svein Erling Tysvaer wrote:

> Alfred,
> why don't you simply create another table with the same structure and a
> primary key and then simply do
>
> INSERT INTO NewTable
> SELECT * FROM OldTable

AFAIK, that insert would fail, and none of the records would be inserted.

One solution would be to create the other table and do:
INSERT INTO NewTable (column_list)
SELECT DISTINCT column_list FROM OldTable;

--
Milan Babuskov
http://fbexport.sourceforge.net