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

HTH

Pieter

"Rose" wrote in message
news
I have two tables that are identical except they contain differant records.
What is the easiest way to combine them into one?
--
Rose