SELECT ID, Billno, Name, Date, Shipped_Details, Order_Number, Sno,
pi.Name as Product_Name, Description, Hsn_Code, Qty, Unit, Rate, Amount, Discount, Taxable_Amount,
CGST_Rate, CGST_Amt, SGST_Rate, SGST_Amt, IGST_Rate, IGST_Amt, totalgst, Addcost, Sub_Total, Sub_Discount, Total_Amount, Company_ID
FROM MainBillForm
pd LEFT OUTER JOIN Product AS pi ON pd.Name = pi.Product_IDWHERE (Billno = @billno) AND (Sno <> 0) AND (Company_ID = @cid)
AND Product Name Show form Product Table.....