delete from EMP
WHERE
    EMP_CODE IN 
    (
        SELECT
            t1.EMP_CODE
        FROM
            EMP t1
        inner join EMP_INVALID t2 on
        t1.EMP_CODE = t2.EMP_CODE
        
        WHERE
            t1.VALID_FLG <> '1'
    )
    ;