Create table query not working

stumbler

Registered User.
Local time
Tomorrow, 00:04
Joined
Jul 30, 2008
Messages
13
Hello,

When I try:
Code:
create table temp  as
(SELECT * FROM [tblOrder-master] WHERE order='2012102302');
i get error:
instruction CREATE TABLE contains syntax error.

Anyone that can help?
 
found solution myself (on this forum)
SELECT * INTO [B_match]
FROM [B_All]
 

Users who are viewing this thread

Back
Top Bottom