Joining two tables from different databases 1

[shyamal]

How would one join tables from different databases:
dbo.Service\ table name CPI\ field name: cpi_number
dbo.Daisy table name Fund \field name: loan_number

CPI_number and loan_number are the same, just called differently in the two tables. I need to find the common loan numbers from both tables in different databases.

Thanks in advance,
Shyamal

 

[tlbroadbent]

Joins are the same. Just need to fully qualify or name the tables using dbname.owner.table format.

SELECT ...
FROM dbo.Service.CPI c
INNER JOIN dbo.Daisy.Fund f
ON c.cpi_number=f.loan_number Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[shyamal]

Thanks Terry what worked was the following...just a few small modifications:

SELECT cpi_number
FROM Servicing.dbo.cpi c
INNER JOIN Daisy.dbo.fund f
ON c.cpi_number=f.loan_number