select *
from nih nih
inner join nir nir on nir.nir_kn = nih.nih_nir_kn