R RainX Registered User. Local time Today, 10:31 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
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, 18:31 Joined May 10, 2003 Messages 574 Oct 25, 2007 #2 SELECT * INTO [B_match] FROM [B_All] ^
R RainX Registered User. Local time Today, 10:31 Joined Sep 22, 2006 Messages 89 Oct 25, 2007 #3 Worked perfectly! Thanks alot