SQL Queries - CAST Knowledge Base - Queries on links - How to get links between objects

SELECT a.idacc         AS link_id, 
       kClr.idkey      AS CALLER_ID, 
       kClr.keynam     AS CALLER_NAME, 
       ofnClr.fullname AS CALLER_FULL_NAME, 
       tClr.typnam     AS CALLER_TYPE_NAME, 
       tClr.typdsc     AS CALLER_TYPE_DESCRIPTION, 
       kCle.idkey      AS CALLEE_ID, 
       kCle.keynam     AS CALLEE_NAME, 
       ofnCle.fullname AS CALLEE_FULL_NAME, 
       tCle.typnam     AS CALLEE_TYPE_NAME, 
       tCle.typdsc     AS CALLEE_TYPE_DESCRIPTION 
FROM   acc a 
       JOIN keys kClr 
         ON kClr.idkey = a.idclr 
       JOIN keys kCle 
         ON kCle.idkey = a.idcle 
       JOIN objfulnam ofnClr 
         ON ofnClr.idobj = kClr.idkey 
       JOIN objfulnam ofnCle 
         ON ofnCle.idobj = kCle.idkey 
       JOIN typ tClr 
         ON tClr.idtyp = kClr.objtyp 
       JOIN typ tCle 
         ON tCle.idtyp = kCle.objtyp 
WHERE  kClr.idkey = '<CALLER_OBJECT_ID>' 
       AND kCle.idkey = '<CALLEE_OBJECT_ID>'; 

SELECT a.idacc         AS link_id, 
       kClr.idkey      AS CALLER_ID, 
       kClr.keynam     AS CALLER_NAME, 
       ofnClr.fullname AS CALLER_FULL_NAME, 
       tClr.typnam     AS CALLER_TYPE_NAME, 
       tClr.typdsc     AS CALLER_TYPE_DESCRIPTION, 
       kCle.idkey      AS CALLEE_ID, 
       kCle.keynam     AS CALLEE_NAME, 
       ofnCle.fullname AS CALLEE_FULL_NAME, 
       tCle.typnam     AS CALLEE_TYPE_NAME, 
       tCle.typdsc     AS CALLEE_TYPE_DESCRIPTION 
FROM   acc a 
       JOIN keys kClr 
         ON kClr.idkey = a.idclr 
       JOIN keys kCle 
         ON kCle.idkey = a.idcle 
       JOIN objfulnam ofnClr 
         ON ofnClr.idobj = kClr.idkey 
       JOIN objfulnam ofnCle 
         ON ofnCle.idobj = kCle.idkey 
       JOIN typ tClr 
         ON tClr.idtyp = kClr.objtyp 
       JOIN typ tCle 
         ON tCle.idtyp = kCle.objtyp 
WHERE  kClr.idkey = '<CALLER_OBJECT_ID>' 
       AND kCle.idkey = '<CALLEE_OBJECT_ID>'; 

SELECT a.idacc         AS link_id, 
       kClr.idkey      AS CALLER_ID, 
       kClr.keynam     AS CALLER_NAME, 
       ofnClr.fullname AS CALLER_FULL_NAME, 
       tClr.typnam     AS CALLER_TYPE_NAME, 
       tClr.typdsc     AS CALLER_TYPE_DESCRIPTION, 
       kCle.idkey      AS CALLEE_ID, 
       kCle.keynam     AS CALLEE_NAME, 
       ofnCle.fullname AS CALLEE_FULL_NAME, 
       tCle.typnam     AS CALLEE_TYPE_NAME, 
       tCle.typdsc     AS CALLEE_TYPE_DESCRIPTION 
FROM   acc a 
       JOIN keys kClr 
         ON kClr.idkey = a.idclr 
       JOIN keys kCle 
         ON kCle.idkey = a.idcle 
       JOIN objfulnam ofnClr 
         ON ofnClr.idobj = kClr.idkey 
       JOIN objfulnam ofnCle 
         ON ofnCle.idobj = kCle.idkey 
       JOIN typ tClr 
         ON tClr.idtyp = kClr.objtyp 
       JOIN typ tCle 
         ON tCle.idtyp = kCle.objtyp 
WHERE  kClr.idkey = '<CALLER_OBJECT_ID>' 
       AND kCle.idkey = '<CALLEE_OBJECT_ID>';