I have 2 tables. Table1 has unique or distinct records and Table2 has duplicate rows or records. I need to join the 2 tables and then aggregate some fields in Table2 where there is a match in Table1. I have 55,000 records in Table1 so the output will only have matches to those records with Table2 values rolled up or aggregated. Thanks!
Here's the essence of it. You basically need to adjust the names where necessary and decide which columns you need in place of . select , sum(t2.LoanAmt) as AggLoanAmt from Table1 t1 inner join Table2 t2 on
t1.ID group by