Thread: Merging Tables
View Single Post
Old November 13th, 2006, 05:49 AM
drnesr drnesr is offline
Registered User
Join Date: Nov 2006
Location: Alexandria, Alexandria, Egypt.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts

peace be upon you Charlotte89 and every reader

In order to merge several tables into one table there are two ways
    1-"Vertical merge" if the small tables have the same field names so you can merge them by an action query like the Append Query. Just create a copy of one of the tables (to be the core of others), then create an append query for another smallTable and execute it then change then name of the smallTable in the SQL view to the next one and so on.
    2-"Horizontal merge" if the small tables have different field names but only one common field, so merge them by making a relational Select query.

Best regards

Dr. Mohammad El-Nesr
Irrigation Systems Design Specialist