Pnkl

Pnkl

  • NA
  • 114
  • 66k

Get Record from Two Database in Single Sql Query Or Sp

Apr 24 2015 5:39 AM

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


Answers (5)