select *
from tsn tsn
inner join ts ts on ts.ts_kc = tsn.tsn_kc_1