creating 1 new set of data from 2 tables

  • Thread starter Thread starter red6000
  • Start date Start date
R

red6000

Hi I have 2 identical tables (in field names).

I want to create a query which extracts all data from both tables (ie append
table 2 onto the end of table1, but in a new table/query leaving the
original tables intact).

I know this should easy, but I just cant see the wood for the trees.

Thanks.
 
You can do a union query which is a query with data from both tables,
and leaves the tables as is:

SELECT * FROM [TABLE1]
UNION SELECT * [TABLE2]
;
 
Thank you Kerry, I knew it was gonna be easy but just couldn't suss it. Ta!

Kerry said:
You can do a union query which is a query with data from both tables,
and leaves the tables as is:

SELECT * FROM [TABLE1]
UNION SELECT * [TABLE2]
;

Hi I have 2 identical tables (in field names).

I want to create a query which extracts all data from both tables (ie
append
table 2 onto the end of table1, but in a new table/query leaving the
original tables intact).

I know this should easy, but I just cant see the wood for the trees.

Thanks.
Click to expand...
Click to expand...
 
SELECT * INTO tblNew
FROM
(SELECT tblOLD1.* FROM tblOLD1
UNION ALL
SELECT tblOLD2.* FROM tblOLD2) ;
 
Back
Top