I have three tables Stock,InwardEntry,IssueToProd. Part_no in stock is a primary key and partno in inwardEntry and IssueToProd is foreign key of stock table's column partno I ma getting wrong sum values of i.InvoiceQuantity,p.IssueQuantity column(display 600 instead of 200)
My sql query is :
select s.partno,s.partname,sum(i.InvoiceQuantity),sum(p.IssueQuantity) from Stock s left join InwardEntry i on s.partno=i.partno left join IssueToProd p on s.partno=p.partno group by s.partno,s.partname
Please visit the following links:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.