SQL Queries - CAST Knowledge Base - Queries on User Project - How to get User Project ID

 SELECT p.IdPro ,
       k.KeyNam,
       t.IdTyp ,
       t.TypNam
FROM   (SELECT DISTINCT op.IdPro
       FROM             ObjPro op
       
       UNION
       
       SELECT DISTINCT a.IdPro
       FROM            Acc a
       )
       p
       JOIN Keys k
       ON     k.IdKey = p.IdPro
       AND    k.ObjTyp NOT IN (306,
                               527)
       JOIN Typ t
       ON     t.IdTyp = k.ObjTyp;