SELECT d.Mnemonic, d.Name, m.MapTo AS ClaimCode
FROM mat.MisDischDispos_Main d
JOIN mat.MisFieldMap_Maps m
  ON m.MapFromID   = d.Mnemonic
 AND m.SourceID    = d.SourceID
 AND m.MisFieldMapID = 'DISCH DISPOS'