SELECT DISTINCT

t2.Number

,t1.Name

,t1.Country

FROM table2 t2

LEFT JOIN table1 t1 ON t2.Number = t1.Number;