Multiple Table Problem

[mike1975]

I have a database that links across our network into other databases. It links to the same table in each 'networked' database so therefore I have eight linked tables in my master database. Each table has exactly the same properties and field names.

My question is this: Is there anyway that I can pull all these tables into one table or query that I can then use for analysis?

I hope there is otherwise I will have wasted approxomately 2 months work!!!!

Mike

 

[Craig0201]

Mike,

Hmmmm.....Perhaps better planning to see if you could do this might have been in order!!!!

But......yes, there is.......

In a query in SQL view,

SELECT * FROM Table1
UNION
SELECT * FROM Table2
UNION
etc......

Craig