Create table and update 1

[Michael57]

I want to create a table with an sql script that will take only some values from another table. How can I do this.

 

[gmmastros]

create a table
Select into

only some values from another table.
Use a where clause

Ex:

Select *
Into   NewTable
From   ExistingTable
Where  SomeValue = 400

-George

"the screen with the little boxes in the window." - Moron