SQL Suery to join Two table

Bineesh Viswanath

13y1.7k

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

3 Replies

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

Hemant Srivastava13y ago
Accepted answer
Without SQL Join:
SELECT PROD.productId, BACH.barcode, PROD.productName, PROD.Quantity, PROD.Rate, PROD.Amount
FROM tbl_Product AS PROD, tbl_Batch AS BACH
WHERE PROD.productId = BACH.productId

With SQL Join:
SELECT PROD.productId, BACH.barcode, PROD.productName, PROD.Quantity, PROD.Rate, PROD.Amount
FROM tbl_Product AS PROD
INNER JOIN tbl_Batch AS BACH ON PROD.productId = BACH.productId

If tbl_Batch table has null entries corresponding to a productId:

SELECT PROD.productId, BACH.barcode, PROD.productName, PROD.Quantity, PROD.Rate, PROD.Amount
FROM tbl_Product AS PROD
LEFT OUTER JOIN tbl_Batch AS BACH ON PROD.productId = BACH.productId
0
Sanjeeb Lenka13y ago
try this

Select p.productId,p.productName,b.Barcode,p.Quantity,p.rate,p.amount
from tbl_Product p inner join
tbl_Batch b on p.productId=b.productId
0
Raju Katare13y ago
Select a.productId,b.barcode,a.productName,a.quantity,a.rate,a.Amount From
tbl_Product a INNER JOIN tbl_Batch b ON a.ProductId = b.ProductId
0