SQL Server allows you to join tables from different databases as long as those databases are on the same server. The join syntax is the same; the only difference is that you must fully qualify table names.
Let's suppose you have two databases on the same server - Db1 and Db2. Db1 has a table called Clients with a column ClientId and Db2 has a table called Messages with a column ClientId (let's leave asside why those tables are in different databases).
Now, to perform a join on the above-mentioned tables you will be using this query:
select *
from Db1.dbo.Clients c
join Db2.dbo.Messages m on c.ClientId = m.ClientId
You could use Synonyms part in the database.
https://i.stack.imgur.com/iiKhP.png
https://i.stack.imgur.com/za7Sz.png
Follow WeChat
Success story sharing
Want to stay one step ahead of the latest teleworks?
Subscribe Now相似问题
- When and why are database joins expensive?
- Can I concatenate multiple MySQL rows into one field?
- SQL JOIN - WHERE clause vs. ON clause
- INNER JOIN ON vs WHERE clause
- When should I use CROSS APPLY over INNER JOIN?
- Selecting data from two different servers in SQL Server
- How to query MongoDB with "like"
- How do I import an SQL file using the command line in MySQL?
