看起来您想消除重复项，可以使用 select distinct :

select distinct t1.id_number, t1.id, t2.id_type, t2.id_value
from table1 t1 join
     table2 t2
     on t2.id = t1.id;