creating 1 new set of data from 2 tables

[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.

 

[Kerry]

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]
;

 

[red6000]

Thank you Kerry, I knew it was gonna be easy but just couldn't suss it. Ta!

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.

 

[Guest]

SELECT * INTO tblNew
FROM
(SELECT tblOLD1.* FROM tblOLD1
UNION ALL
SELECT tblOLD2.* FROM tblOLD2) ;