copy data from table 1 to table2

You should try on google first. Anyway her is the answer

INSERT INTO [table 1] (p_name, ppo_no, acc_no)
SELECT p_name, ppo_no, acc_no FROM [table 2]

Hi,


Try this...

--both table structure should match

insert into table2
Select * from table1

--or

insert into table2 (p_name, ppo_no, acc_no)
Select p_name, ppo_no, acc_no from table1

It is also advisable that you must go through the link given in Solution 1 to get detailed knowledge.

Hope this will help you.

Cheers