Join Tables

From: "phuser" <lori_paff@xxxxxxxxxxx>
Date: Mon, 17 Jul 2006 09:43:53 -0600

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.

.

Follow-Ups:
- Re: Join Tables
  - From: phuser

Prev by Date: Re: Multiple Prices for same product
Next by Date: Re: Records will not append to another table due to Key violations
Previous by thread: Re: Multiple Values for one field
Next by thread: Re: Join Tables
Index(es):
- Date
- Thread

Relevant Pages

Join Tables with same data
... I have 3 tables from 3 different databases they are exactly the same in ... I have given them each their own name for data integrity ... but I have to create a duplicate query for each location if I am ... I would also have to create an append query to ...
(microsoft.public.access.tablesdbdesign)
Re: Natural keys vs Aritficial Keys
... When I learned databases, about a quarter of a century ago, the preferred ... Every time the issue of natural keys comes up in Stackoverflow.com, ... automatically when you declare a PRIMARY KEY). ... invitation to degradation of data integrity. ...
(comp.databases.theory)
Re: Check integrity data in distributed database
... What do you mean with data integrity? ... Do you mean to check if two databases ... Andrés ... > Please tell me the way to check data integrity between server1 and ...
(microsoft.public.sqlserver.server)