If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combine tables
I have two tables that are identical except they contain differant records.
What is the easiest way to combine them into one? -- Rose |
#2
|
|||
|
|||
Combine tables
use an append query but make sure you have a unique identifier for each row -- The 11th day of every month: http://truthaction.org/forum/index.php "Rose" wrote: I have two tables that are identical except they contain differant records. What is the easiest way to combine them into one? -- Rose |
#3
|
|||
|
|||
Combine tables
Rose,
Create an Append Query to add the records from one table into the other. Make sure you backup both original tables before doing the Append. -- hth Al Campagna Access MVP 2007 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love, and you'll never work a day in your life." "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 |
#4
|
|||
|
|||
Combine tables
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 |
Thread Tools | |
Display Modes | |
|
|