Hi,

Try this,

SELECT ISNULL(T1.id,T2.id) id,ISNULL(T1.region,T2.region) region,ISNULL(T1.Lamt,0.00) Lamt,ISNULL(T2.lamt,0.00) Iamt

FROM@t1 T1

FULL OUTER JOIN @t2 T2 ON T1.id = T2.id AND T1.region = T2.region

Regards,

Adil