Can we use join for two different database tables?

by

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

More Related Contents:

  1. What is the result of following SQL Query?
  2. How to display data in JOIN, and return null value? [closed]
  3. How can I do a FULL OUTER JOIN in MySQL?
  4. Join vs. sub-query
  5. SQL JOIN – WHERE clause vs. ON clause
  6. Can I use CASE statement in a JOIN condition?
  7. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  8. Why isn’t SQL ANSI-92 standard better adopted over ANSI-89?
  9. Subqueries vs joins
  10. SQL to LINQ with multiple join, count and left join
  11. Difference between left join and right join in SQL Server [duplicate]
  12. Multiple INNER JOIN SQL ACCESS
  13. Oracle “(+)” Operator
  14. JOIN two SELECT statement results
  15. SQL Join Differences
  16. Implement paging (skip / take) functionality with this query
  17. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  18. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  19. Natural join in SQL Server
  20. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  21. Including null values in an Apache Spark Join
  22. Is a JOIN faster than a WHERE?
  23. Select only rows by join tables max value
  24. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  25. What is semi-join in database?
  26. Merge two rows in SQL
  27. Joining multiple tables in SQL
  28. sql sum data from multiple tables
  29. SQL server join tables and pivot
  30. SQL join on multiple columns in same tables

Leave a Comment