SQL Queries - CAST Knowledge Base - Queries on Links - How to get the name of the project and the type of the project for a given link

SELECT ac.idacc as "ID OF THE LINK",
       k1.keynam as "NAME OF THE CALLER",
       k2.keynam as "NAME OF THE CALLEE",
       kt.keynam as "NAME OF THE PROJECT",
       t.typdsc as "NAME OF THE TYPE OF PROJECT"
FROM   acc ac 
       JOIN keys k1 
         ON k1.idkey = ac.idclr
       JOIN keys k2
         ON k2.idkey = ac.idcle
       JOIN Keys kt
         ON kt.idkey = ac.idpro
       JOIN typ t 
         ON t.idtyp = kt.objtyp 
WHERE k1.keynam like '%<NAME OF THE CALLER OBJECT>%'
AND k2.keynam like '%<NAME OF THE CALLEE OBJECT>%'