Syntax

  • Thread starter Thread starter Dave Karmens
  • Start date Start date
D

Dave Karmens

Could someone help me out with this syntax:

Select * from tbl1 into tbl2

I want to select everything from one table and insert it into another.
 
INSERT INTO tbl2 (col1,col2,...,coln
SELECT col1,col2,...,coln FROM tbl

Should work

Ji

----- Dave Karmens wrote: ----

Could someone help me out with this syntax

Select * from tbl1 into tbl

I want to select everything from one table and insert it into another
 
Back
Top