DELETE
    E
FROM
    EMP AS E
INNER JOIN
    EMP_INVALID AS EI
ON
    E.EMP_CODE = EI.EMP_CODE
WHERE
    E.VALID_FLG <> '1';
    
SELECT
    *
FROM
    EMP;