SQL Query For Copy records from one table to another

[Bellamy]

Hi,
I need some help,
Can anyone tell how to copy records from one table to another table by using SQL Query.

[Praetor]

If you want to create a single, new table with all the records (rather than overwriting one of the existing tables):

SELECT * FROM Table1OfPC1 ;
UNION ;
SELECT * FROM Table1OfPC2 ;
UNION ;
SELECT * FROM Table1OfPC3 ;
INTO TABLE NewTable1

[Katty]

You can use the following query.

insert into newtablename select * from oldtablename

But if you want to Copy only Unique Records from one Table to Another Table
then use this query.

insert into newtablename select distinct * from oldtablename

[Booth]

Hi,

Very nice piece of code.
Short and simple to understand.
Thanks for sharing your knowledge with us.

Keep posting.

[ganeshmandlik]

You can use the following query.

insert into newtablename select * from oldtablename

But if you want to Copy only Unique Records from one Table to Another Table
then use this query.

insert into newtablename select distinct * from oldtablename

This is very simple & good idea to copy records from 1 table to another which is already existing Thank You.