I assume that you are trying to match values of StatusNum from table2 and status from table1

select

b.StatusName

from querytable.dbo.table1...