Código SQL [-]select A.clave from tabla A left join (select clave from tabla C where C.fecha >:fecha) B on A.clave = B.clave where B.clave is null group by A.Clave
select A.clave from tabla A left join (select clave from tabla C where C.fecha >:fecha) B on A.clave = B.clave where B.clave is null group by A.Clave