I am trying to display data from two databases.
in case of one database we can join multiple tables.
But how to join tables in multiple database.
If you are using the databases on the same server you will be able to use them by using there fully qualified names "<database>.<schema>.<Table>", as long as you have permission to access the tables in each database.
If the databases are on different servers you will first need to create a linked server on the database servers and then use the four part name for the table... "<server>.<database>.<schema>.<Table>", Check linked servers in the books online.
No comments:
Post a Comment