select p.purchaseBillId,p.Accountid,a.accountname,p.Netamount, pd.ProductId,pr.productname,s.batchno,s.salerate,pd.TotalValue from purchasebills p,purchasebillsdetails pd,accounts a,products pr,stockdetails s where p.purchasebillid=pd.purchasebillid and pd.productid=pr.productid and pd.productid=s.productid and pd.batchno=s.batchno and p.accountid=a.accountid and p.purchasebillid=321
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)