SQL Suery to join Two table

Question

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

Hemant Srivastava · 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

Sanjeeb Lenka · Answer

try this Select p.productIdp.productNameb.Barcodep.Quantityp.ratep.amount from tbl_Product p inner join tbl_Batch b on p.productId=b.productId

Raju Katare · Answer

Select a.productIdb.barcodea.productNamea.quantitya.ratea.Amount From tbl_Product a INNER JOIN tbl_Batch b ON a.ProductId = b.ProductId