MS Access - creating tables based on query
#1
Scooby Regular
Thread Starter
Join Date: Sep 2001
Location: A powerslide near you
Posts: 10,261
Likes: 0
Received 0 Likes
on
0 Posts
MS Access - creating tables based on query
Hi
I have a query that brings back a number of records. I need a NEW table that contains the results of this query. Should be simple, but how do you do it?
Also (and probably related to above prob), I have a table that I want to select a number of records (or all of them) and insert them to the end of another table.
Essentially, using access, I want to replicate the following SQL:
INSERT INTO table_b B
( SELECT x, y, z FROM table_a A WHERE y = 'abc')
;
I have a query that brings back a number of records. I need a NEW table that contains the results of this query. Should be simple, but how do you do it?
Also (and probably related to above prob), I have a table that I want to select a number of records (or all of them) and insert them to the end of another table.
Essentially, using access, I want to replicate the following SQL:
INSERT INTO table_b B
( SELECT x, y, z FROM table_a A WHERE y = 'abc')
;
#2
Originally Posted by Dracoro
Hi
I have a query that brings back a number of records. I need a NEW table that contains the results of this query. Should be simple, but how do you do it?
Also (and probably related to above prob), I have a table that I want to select a number of records (or all of them) and insert them to the end of another table.
Essentially, using access, I want to replicate the following SQL:
INSERT INTO table_b B
( SELECT x, y, z FROM table_a A WHERE y = 'abc')
;
I have a query that brings back a number of records. I need a NEW table that contains the results of this query. Should be simple, but how do you do it?
Also (and probably related to above prob), I have a table that I want to select a number of records (or all of them) and insert them to the end of another table.
Essentially, using access, I want to replicate the following SQL:
INSERT INTO table_b B
( SELECT x, y, z FROM table_a A WHERE y = 'abc')
;
Thread
Thread Starter
Forum
Replies
Last Post
Sam Witwicky
Engine Management and ECU Remapping
17
13 November 2015 10:49 AM