SELECT f2.A, f2.B, f2.C, COALESCE(f1.C, 'NO MATCH') as D
  FROM f2 LEFT JOIN f1 ON f1.A = f2.A AND f1.B = f2.B