insert data from one table to another table
by Ramya[ Edit ] 2008-11-24 08:57:38
insert data from one table to another table:
INSERT table2 (id, lname, fname)
SELECT id, lname, fname
FROM table1
WHERE State = 'TN';
Replace the VALUES clause with a SELECT statement that will return a set of records.
Before doing this confirm make sure that the table1 has all the values you want to insert.