I have 10 db's. In each db I have a query. I want to make a single table in one db that is the sum of all the queries. There is a common field in each query, SITE_ID, there should be no duplication. Eg Query in DB1 might have sites 1-10, query in DB2 might have sites 11-20, etc. I want a table that lists sites 1-20?
What is the simplest way? I am sure there must be a really straightforward way?
Any help much appreciated.
Rob
What is the simplest way? I am sure there must be a really straightforward way?
Any help much appreciated.
Rob