select Table1.id, Table2.name, Table2.address, sum(Table1.amount) from Table2 inner join Table1 on Table2.id=Table1.id group by Table1.id, Table2.name, Table2.address;
select id, name, address, sum(amount) from table2 group by id, name, address
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)