asked on

Three Table Join in SQL Server Database

Here is my scenerio, I have three separate Windows 2008 Servers not clustered and are running sql and each has the following:

Server A: Database supporting Web application with the following:
TableName: Manager
ManagerID
ManagerName

Server B: User databases
TableName: Manager
ManagerID
ManagerName

Server C: User databases
TableName: Manager
ManagerID
ManagerName

Now the question is this----I want to create a View on Server A with the Manager data, having a three table joins, so the Web App can always query the view on Server A without having to touch the tables on other instances, definately the view is going to be three table joins, how can this be achieve without having to set up a Linked Server???

Remember, I'm only retrieving data from one table each.

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

AnuTiji

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Favorable

ASKER

Remember, these are differents Servers, and the View will be created one time on the Web Application database on Server A and anytime the View is query on server A it will retrieve similar data from Server B, and Server C.

ASKER CERTIFIED SOLUTION