DELETE
FROM EMP
WHERE EMP_CODE
    IN (
        SELECT X1.EMP_CODE
        FROM EMP X1
            JOIN EMP_INVALID X2
                ON X1.EMP_CODE = X2.EMP_CODE
        WHERE X1.VALID_FLG <> '1'
    )