Bineesh  Viswanath

Bineesh Viswanath

  • NA
  • 1k
  • 777.5k

SQL Suery to join Two table

Oct 28 2013 6:45 AM
Sir, I need your help to give me a sql query:

Firstly take a look to the table I have:

1)tbl_Product
-----------------

productId
productName
rate
quantity
Amount

2) tbl_Batch
--------------
batchId
productId
Barcode

Please give me a query to have a output like below:

productId                   barcode                     productName                  Quantity                Rate                 Amount

Answers (3)