name amt month year id H12 1453098.00 9 2010 1458 H12 25739446.00 10 2010 1458
name namt month year id H11 7600518.00 10 2010 1465 H12 239937.00 10 2010 1458
select distinct t1.amt ,t2.namt, t1. id,t1.month from table1 t1 left outer join table2 t2 on t1.name=t2.name and t1.id=t2.id it is resulting the rows
amt namt id month 1453098.00 239937.00 1458 9 25739446.00 239937.00 1458 10
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)