DELETE 
    FROM 
        EMP AS tbl_e
    WHERE tbl_e.VALID_FLG != '1' 
    AND tbl_e.EMP_CODE in (SELECT tbl_ei.EMP_CODE FROM EMP_INVALID AS tbl_ei);