select *
from kck kck
inner join kco kco on kco.kco_kurz = kck.kck_kco_idpk