S stumbler Registered User. Local time Tomorrow, 00:04 Joined Jul 30, 2008 Messages 13 Nov 25, 2012 #1 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?
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?
S stumbler Registered User. Local time Tomorrow, 00:04 Joined Jul 30, 2008 Messages 13 Nov 25, 2012 #2 found solution myself (on this forum) SELECT * INTO [B_match] FROM [B_All]