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_ID
WHERE (Billno = @billno) AND (Sno <> 0) AND (Company_ID = @cid)
AND Product Name Show form Product Table.....

Rafnas T PPosted Jun 28, 2017, 3:04 AM
Rafnas T PPosted Jun 28, 2017, 3:55 AM
Jyoti JodhaPosted Jun 28, 2017, 3:44 AM
Dynamic SQL Generated is not supported against multiple base table
Dynamic SQL Generated is not supported against multiple base table
Rafnas T PPosted Jun 28, 2017, 3:29 AM
Jyoti JodhaPosted Jun 28, 2017, 3:15 AM