Is this simpler?

;with cte as

(

select m.RecordId,m.NumberForSearch,

a.AlphaNumeric2,a.AlphaNumeric5,a.AlphaNumeric7,a.AlphaNumeric9

from table1 m join table2 a on m.RecordId = a.RecordId

where RecordId = 3212

)

select RecordId,NumberForSearch into #dump

from cte...