Get Record from Two Database in Single Sql Query Or Sp

Question

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

Nanhe Siddique · Answer

use this code SELECT idCustomerNameProductNameOrderAmt FROM [ Customer ].[ dbo ].[ CustomerPurchaseMaster ] tab1 INNER JOIN [ Product ] .[ dbo ].[ ProductMaster ] tab2 ON tab1 . ProductId = tab2 .ProductID

Sneha Sneha · Answer

use this query:- Select * from CustomerPrchaseMaster innerjoin ProductMaster on CustomerPurchaseMaster.ID = ProductMaster.ProductID;

Pnkl · Answer

Dear Rajeev Ranjan Also Your Answer is a accepted. Thank you to Rajeev Ranjan And Nanhe Siddique

Rajeev Ranjan · Answer

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]

Pnkl · Answer

Hello Sneha I have to get record from two Different Database not from single Database in single query