Create table AS Select Query

RainX

Registered User.
Local time
Today, 10:31
Joined
Sep 22, 2006
Messages
89
Hello all,

Is there anyway to create a table from a query like you can in oracle?
i.e.

Create Table [B_match] AS
SELECT *
FROM [B_All]

Take care
 
SELECT * INTO [B_match]
FROM [B_All]

^
 
Worked perfectly!
Thanks alot
 

Users who are viewing this thread

Back
Top Bottom