select m.YoA,m.Currency,ISNULL(a.Amt,0)

from MasterTbl m

Left Outer Join

Amount as a

on (m.YoA=a.YoA AND m.Currency=a.Currency)

-- This Should be one of the possible solution ...