Newbie Q: How to Combine data from two tables from two different databases

From: "Michelle" <nospam_mbytwo-news@xxxxxxxxxxxx>
Date: Tue, 4 Jul 2006 16:17:27 +1000

Hi

I have two separate SQL server databases: DB1 and DB2

Both databases contains similar tables and I have to combine some of the
like tables together.
If I create an INSERT INTO statement, how do I reference the DB1 and DB2
specific tables?

I will be appreciative for responses or links to areas that I can further
read up.

TIA
Michelle

.

Follow-Ups:
- Re: Newbie Q: How to Combine data from two tables from two different databases
  - From: Tibor Karaszi

Prev by Date: RE: Job Calendar
Next by Date: Re: Newbie Q: How to Combine data from two tables from two different databases
Previous by thread: RE: Job Calendar
Next by thread: Re: Newbie Q: How to Combine data from two tables from two different databases
Index(es):
- Date
- Thread

Relevant Pages

Re: Newbie Q: How to Combine data from two tables from two different databases
... I have two separate SQL server databases: ... If I create an INSERT INTO statement, how do I reference the DB1 and DB2 specific tables? ...
(microsoft.public.sqlserver.tools)
Re: Newbie Q: How to Combine data from two tables from two different databases
... I have two separate SQL server databases: ... If I create an INSERT INTO statement, how do I reference the DB1 and DB2 ...
(microsoft.public.sqlserver.tools)
Re: Eine Tabelle in der Datenbank 1 mit Formular aus Datenbank 2 f
... DB2 dient zur Erfassung der Mitarbeiter und der Schulung, DB1 dient der ... da gibt es eben bereits das Formular mit den Stammdaten. ... Stammdatentabelle DB2 auf, geht in das Formular und legt den MA an, schließt ...
(microsoft.public.de.access)
Re: physikalische Datenbank-Struktur
... (im Weiteren sei DB1 die "Haupt-"Datenbank, ... deren Ziel-Tabellen in DB2 liegen): ... Deutliche Verbesserungen konnte ich feststellen, ... mit DB2, auch wenn ich diese Verbindung weiter gar nicht nutze. ...
(microsoft.public.de.vb.datenbank)
Table Synchronization across databases on the same server
... inhouse application which maintains a transactional database, DB2 also ... Since the DB1 is frequently updated the ...
(comp.databases.ms-sqlserver)