Copy values from one table to another
686815Feb 23 2009 — edited Feb 23 2009i create table1 with 8 fields.Now i have table2 which is already existing one,but its structure is different from table1 ie it contains 15 fields.
Can i copy some values from second table into first one using
insert into tab1(...,....,....)
select ( ...,...,...) from tab2?