Cita:
Iniciado por Jorge_Mota select * from persona where idp not in (select idp from curso_Detalle where curso = 1)
gracias!!!!!!
finalmente quedó así el query:
Código:
SELECT DISTINCT P.Rut, p.nombre,p.apepat,p.apemat
FROM ActDet a, Personal p
WHERE (P.CodCCosto = 5)
AND (P.CodEmp = 'MAS')
AND (P.Rut NOT IN (SELECT rut FROM actdet WHERE A.CodAct = 2))
GRACIELA