Link to home
Create AccountLog in
Avatar of LouisvilleGeek
LouisvilleGeekFlag for United States of America

asked on

Inner join across an instance

I am currently trying to inner join between two databases.  One of them is a true database, and the other is an instance.  While I can pull records from one without a hitch (they have been linked), when I try to perform the join, I'm told that it cannot find the column in question.  Here's the statement I've been trying:

SELECT equipmentId
FROM [CHSQL01\ABOUTTIME].[abtt].[dbo].[Equipment]
INNER JOIN VPTest.dbo.bEMEM
ON [CHSQL01\ABOUTTIME].[abtt].[dbo].[Equipment].[equipmentCode] = VPTest.dbo.bEMEM.Equipment

Open in new window

And this is the error, I'm receiving:
Msg 4104, Level 16, State 1, Line 4
The multi-part identifier "CHSQL01\ABOUTTIME.abtt.dbo.Equipment.equipmentCode" could not be bound.

Open in new window

Any help is greatly appreciated.  Thanks in advance!
ASKER CERTIFIED SOLUTION
Avatar of HainKurt
HainKurt
Flag of Canada image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of LouisvilleGeek

ASKER

Thanks!