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
125
2
220
3
300
DB: Product à Table : ProductMaster
ProductName
Pendrive
Mouse
Router
Required Result Table Output