Combine duplicate tables in to single query

[Binnit]

I have 8 almost replica versions of a database being used each with their own unique data.

Each db has a specific table that I need data the data from(all with same fields/attributes etc) I have created a stand alone db and created a link to each of the 8 tables.

I now wish to build a single query that will provide me with the data from all 8 tables in a single view, the tables cannot be joined as there is no common related data between them.

How do I go about this?

If IT ain’t working Binnit and Reboot

 

[Binnit]

Its Ok, I think I have solved this with Union ALL statement.

Apologies for the wasted posting

Thanks for looking anyway!

If IT ain’t working Binnit and Reboot