🚀 go-pugleaf

Define field1 as auto-increment column and do not use it in your sql - DBMS
will generate this value for you. If you need to preserve fieldA, just add
new primary-key column to new table.

//----------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Sky" <huangc@motic.com> �������/�������� � �������� ���������:
news:3f783748@newsgroups.borland.com...
> Hi all
>
> I'm a database newbie, does anyone can tell me a simple query question?
> I want to insert some record into my table from an old table,
> because I set a primary index in my table, so I require that the record
> are in-repeated(the index column mustn't repeat).
>
> I know how to query a simgle in-repeated column with distinct keyword,
> but I don't know how to query several fields at a time.
>
> this is my sql statement, does anyone can help me compete it?
>
> insert into table1 ( field1, field2, field3)
> select fieldA, fieldB, fieldC
> from table2
>
> table1 is my table and field1 is the primary key.
> table2 is the old table and there are many repeated records(fieldA repeat)
>
> TIA
>
> sky
>
>