Join Tables

[phuser]

Sorry this is a repost

I have 3 tables from 3 different databases they are exactly the same in
structure. They do however each have their own data, is it possible to join
those 3 tables up? I have given them each their own name for data integrity
but I have to create a duplicate query for each location (tedious) if I am
able to join the tables, I would also have to create an append query to
update weekly. Any help would be greatly appreciated.

 

[phuser]

Got it from reading similar posts, created an append query ;-)

 

[KARL DEWEY]

You might use a UNION query if you just want to use the data and not store
what might be changed the next time and you not know it was changed.