how to merge two tables in an access database

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

 

[KARL DEWEY]

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