Re: How query between databases

"Cirene" <cirene@xxxxxxxxxxx> wrote in message news:%23FARSSwyIHA.4848@xxxxxxxxxxxxxxxxxxxxxxx

I have an Employees table in Db1 and a Vacations table in Db2 (SQL Server). Vacations is linked to Employees by EmployeeId.

In SQL how would I join the 2 tables, even though they are from 2 different dbs?

Assuming that the same credentials (userid & password) will work for both:
http://www.developer.com/db/article.php/3613301


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

.

Relevant Pages

  • Windows Authentication
    ... We use windows authentication from a 2k domain to our sql ... server. ... Two of our employees have just got married and ... so changed their surname. ...
    (microsoft.public.sqlserver.security)
  • How query between databases
    ... Vacations is linked to Employees by EmployeeId. ... In SQL how would I join the 2 tables, even though they are from 2 different ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Help needed with server setup at work
    ... Help needed with server setup at work ... home directories for all the employees client machines. ... Most of the employees mount their home dirs manually, ... Putting a union NFS server up is just asking for trouble, ...
    (freebsd-questions)
  • Re: pl/sql: display employees who hired in specific month
    ... So far, when I run my script, all employees (including emp who are ...    END LOOP; ... SQL> -- Your code, using EMP table ... SQL> SET SERVEROUTPUT ON ...
    (comp.databases.oracle.server)
  • Re: How to change an written access program to a a web application
    ... Did you end up writing the access program for the time tracking? ... "Tara" wrote: ... server or hosting service? ... and here is University with 20000 employees and now I ...
    (microsoft.public.access.modulesdaovba)