DELETE
FROM 
    EMP AS e
WHERE
    e.EMP_CODE IN (
        SELECT
            ev.EMP_CODE
        FROM
            EMP_INVALID AS ev
        WHERE
            ev.VALID_FLG<>'1'
    )