Re: Using SQL to create new table based on select results

[Sasha Pachev]

"Webber, William D." wrote:
> 
> Greetings all. I was wondering if there is a way via an SQL statement to
> create a new table and fill it with data from a select statement.
> In Psuedocode:
> select * from MyTable where FirstName like "%A"
> create table MyNewTable( First varchar(20), LastName (20))
> Insert into MyNewTable ( MyNewdata)
> 
> I know the basics of select statements, but do not know how to shoot the
> resulting data into a new table. Can you do that?
> Cheers, Will-
> 

You can do it in two steps:

create table foo ...
insert into foo select ...



-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)