How query between databases

C

Cirene

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate ID issue when trying to copy table row 1
Seperate Databases and Business Logic.. SQL vs. .NET code?? DesignIdeas/Differences 2
How to go about building a crud app when you are a noob 1
DataAdapter and passing query string question 0
On DataTable, two databases 3
ASP.NET 3.5 Dynamic Data and Multiple Databases 1
Multiple Access Databases 13
Sql query 6

Members online

Total: 26 (members: 1, guests: 25)
Robots: 509

Forum statistics

Threads
473,769
Messages
2,569,579
Members
45,053
Latest member
BrodieSola

Latest Threads

Top