DELETE FROM AUTOFORNE
WHERE
  NOT EXISTS 
   (SELECT CDFILDEST FROM ITEMAUTF
    WHERE ITEMAUTF.CDFILDEST = AUTOFORNE.CDFILDEST AND
          ITEMAUTF.CDFILLANC = AUTOFORNE.CDFILLANC AND
          ITEMAUTF.NRAUTOFORN= AUTOFORNE.NRAUTOFORN)
/
COMMIT
/