Combine tables

[Rose]

I have two tables that are identical except they contain differant records.
What is the easiest way to combine them into one?

 

[scubadiver]

use an append query but make sure you have a unique identifier for each row

 

[Pieter Wijnen]

To view all of them
SELECT * FROM TableA
UNION ALL
SELECT * FROM TableB

HTH

Pieter