Pulling data from one table into another table within the same db

[hopper]

I'm trying to pull data from one table and inserting it into another table all within the same db. I am going to delete the first table so not to worry about data dublication. I've tried SELECT INTO... and
INSERT INTO... VALUES(SELECT...) but neither of those seem to work.
If any of you have any clues I'd really appreciate it.
Thanks,
Hopper

 

[hopper]

Nevermind, I got it. Thanks anyway!

 

[MikeKohler]

Hi, I was just wondering how you managed to solve this.
Michael Kohler

 

[ericbrunson]

insert into table2 select whatever from table1 where blah;

 

[cdlvj]

FYI, you can use the create table syntax to do similar stuff.

 

[ericbrunson]

It's so common developers just refer to it by the abbreviation "CTAS".

Create Table newtable AS select blah, blah, blah ...