how to merge two tables in an access database

  • Thread starter Thread starter Rathin
  • Start date Start date
R

Rathin

I have 2 tables for annuity payments. I like to merge data from one to other
keeping all the extra data in table 1 compared to table 2 against a common
field 'annuitant_name'. Also the new names should be in the merged table.
Please help by giving the SQL command. I am a beginner in Access and VB so
please advise in common parlance.
 
Try these queries --
qry_annuitant_List --
SELECT [annuitant_name]
FROM Table1
UNION SELECT [annuitant_name]
FROM Table2;

SELECT Table1.*, Table2.* INTO Table3
FROM qry_annuitant_List LEFT JOIN Table1 ON
(qry_annuitant_List.[annuitant_name] = Table1.[annuitant_name]) AND
qry_annuitant_List.[annuitant_name] = Table2.[annuitant_name];
 
Back
Top