Beginner - copying data from one table to another

Hi,

I want to copy rows from one table to another table where column names are the same

for example

Tab1
  ID CHAR(10)
  NAME CHAR(30)
  PHONE CHAR(15) Tab2
  ID CHAR(10)
  FNAME CHAR(10)
  NAME CHAR(30) Can i write a script that will insert all rows from Tab1 into Tab2 for the identical column names Received on Fri Dec 06 2002 - 02:18:17 CST