select *
from kcm kcm
left outer join ts ts on ts.ts_ina = kcm.kcm_ina