Merging tables

Results 1 to 2 of 2

Thread: Merging tables

  1. #1
    Join Date
    Dec 1969

    Default Merging tables

    how do i merge 2 tables into one table in access, so that records in 3rd table has all records of 1st + 2nd

  2. #2
    Join Date
    Dec 1969

    Default RE: Merging tables

    insert into table3<BR>select * from table1 union <BR>select * from table2<BR><BR>this is provided that all tables have the same columns with regard to type and number. If not, just adjust with dummies in the select lists so they matches.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts