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'........
For best results, use the Firefox browser..