Hi,
I have two tables. One is Table1, the other is Table2. There are Name, Code, Quantity, Price and Date in the Table1. And there are Name, Code, Quantity(Total) in the Table2. I want to calculate the total of a product that their names and code is the same. Then, the name ,code and total is shown in table 2. How can I use the SQL statement? For example, "select sum(quantity) from Table1 where name='A'........
Thanks!
regards,
Smile.
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign