Get Record from Two Database in Single Sql Query Or Sp

Pnkl

I have Two Database on Same Server and I want to get Record from two Database in Single Sql Query Or Stored procedure

Server : 192.168.1.1

Database1 : Customer

Database2 : Product

DB : Customer à Table : CustomerPurchaseMaster

ID	CustomerName	ProductID	OrderAmt
1	James	1	125
2	James	2	220
3	James	3	300

DB: Product à Table : ProductMaster

ProductID	ProductName
1	Pendrive
2	Mouse
3	Router

Required Result Table Output

ID	CustomerName	ProductName	OrderAmt
1	James	Pendrive	125
2	James	Mouse	220
3	James	Router	300

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanhe Siddique11y ago

Accepted answer

use this code

SELECT id,CustomerName,ProductName,OrderAmt  FROM [ Customer].[dbo].[CustomerPurchaseMaster] tab1     INNER JOIN [Product].[dbo].[ProductMaster] tab2
        ON tab1.ProductId= tab2.ProductID

Pnkl11y ago
Dear Rajeev Ranjan,

Also, Your Answer is a accepted.

Thank you to Rajeev Ranjan And Nanhe Siddique
Rajeev Ranjan11y ago
Dear Pnkl,
As i have seen your question.
This can be done by the three simple steps
1) Create a Link sever ( this process is done by any server admin)

2) get the Link server path

3) write our query [ ..[dbo][tableName]
Pnkl11y ago
Hello Sneha,

I have to get record from two Different Database not from single Database in single query
Sneha Sneha11y ago
use this query:- Select * from CustomerPrchaseMaster innerjoin ProductMaster on CustomerPurchaseMaster.ID = ProductMaster.ProductID;