Two tables are distributed in two different databases, how to do a natural join for them.

xhy100

Two tables are distributed in two different databases, how to do a natural join for them. These two databases are placed on the same database server.

小老鹰

format:

Database name.dbo.table name

or

Database name: table name

Such as:

select A. *, B. *
from database 1: Table 1 A
        inner join database 2 .. Table 2 B on A.ID = B.ID

unkmass

If table a is in db1 and table b is in db2

use db2;
select * from db1.dbo.a, b where db1.dbo.a.primary key = b.primary key;

xhy100

ALTER PROCEDURE dbo.SelectAnnounce
AS
/ * SET NOCOUNT ON * /
SELECT A. *
FROM Customer.dbo.Announce A
INNER JOIN aspnetdb.dbo.aspnet_Users U
ON A.AuthorID = U.UserID
/ * select * from Announce * /

Hint: The object name Customer.dbo.Announce A is invalid.
what happened?

xhy100

SELECT *
FROM dbo.Announce
You can query the data.
but
SELECT *
FROM Customer.dbo.Announce
It won't work.

prajna

SELECT A. *
FROM Customer..Announce A
INNER JOIN aspnetdb..aspnet_Users U
ON A.AuthorID = U.UserID

Try this?