DELETE FROM 
    EMP
WHERE
    EMP_CODE IN (
        SELECT 
            EMP_CODE
        FROM
            EMP_INVALID
        WHERE
            VALID_FLG == 0
    );