Create table AS Select Query (1 Viewer)

R

RainX

Registered User.

Local time

Today, 06:33

Joined

Sep 22, 2006

Messages

89

• Oct 25, 2007

• #1

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

 

E

EMP

Registered User.

Local time

Today, 14:33

Joined

May 10, 2003

Messages

574

• Oct 25, 2007

• #2

SELECT * INTO [B_match]
FROM [B_All]

^

 

R

RainX

Registered User.

Local time

Today, 06:33

Joined

Sep 22, 2006

Messages

89

• Oct 25, 2007

• #3

Worked perfectly!
Thanks alot