Mem usage has exceed the limit of BE

Steps to reproduce the behavior (Required)
-- set exec_mem_limit =<PHONE_NUMBER>4; insert into   case_info_copy (     new_case_accord,     case_accord_text,     RELATION_DEPTSCODE,     ENTERPRISE_NAME,     APPLICANT_TYPE,     COMPLAINT_DETAIL,     RQSTSOURCECHILD,     ISKAOHE,     flagguid,     flag,     FDBACK,     SEND_TIME,     FDBACKTIME,     SIGN_TIME,     HANDLETIME_LONG,     FINISH_TYPE,     FINISH_NOTE,     FINISH_TIME,     CONCACT_TIME,     END_NAME,     END_DEPT,     VISIT_TYPE,     VISIT_REMARK,     SUBJECT_RESULT_SATIFY,     OPERATEDATE1,     REQUENCY,     OPERATEDATE,     THEME_SERIAL,     CASE_HISTORYNUM,     CERTIFICATE_TYPE,     CASE_GOAL,     EVENT_DATE,     CASE_ADDRESS,     CASE_EX_ACCORD,     CASE_EMOTION,     CASE_LNGLAT,     CASE_AREA_CODE,     RELATE_SERIAL,     TBACKTIME_BF,     TFDBACKTIME_BF,     TSIGNTIME_BF,     CASE_SERIAL_TURN,     AREA_CODE,     CASE_MARK,     CASE_ISURGENT,     CASE_ISVISIT,     CASE_ISPUBLIC,     CASE_PROCESS_TYPE,     CASE_CONTENT,     CASE_ACCORD,     CASE_TYPE,     APPLICANT_ID,     APPLICANT_AGE,     APPLICANT_SEX,     APPLICANT_NAME,     PHONE_NUMBER,     CASE_SOURCE_DETAIL,     CASE_SOURCE,     CASE_DATE,     CASE_REGISTERNO,     CASE_REGISTER,     CASE_TITLE,     CASE_SERIAL,     ROWGUID   ) select   new_case_accord,   case_accord_text,   RELATION_DEPTSCODE,   ENTERPRISE_NAME,   APPLICANT_TYPE,   COMPLAINT_DETAIL,   RQSTSOURCECHILD,   ISKAOHE,   flagguid,   flag,   FDBACK,   SEND_TIME,   FDBACKTIME,   SIGN_TIME,   HANDLETIME_LONG,   FINISH_TYPE,   FINISH_NOTE,   FINISH_TIME,   CONCACT_TIME,   END_NAME,   END_DEPT,   VISIT_TYPE,   VISIT_REMARK,   SUBJECT_RESULT_SATIFY,   OPERATEDATE1,   REQUENCY,   OPERATEDATE,   THEME_SERIAL,   CASE_HISTORYNUM,   CERTIFICATE_TYPE,   CASE_GOAL,   EVENT_DATE,   CASE_ADDRESS,   CASE_EX_ACCORD,   CASE_EMOTION,   CASE_LNGLAT,   CASE_AREA_CODE,   RELATE_SERIAL,   TBACKTIME_BF,   TFDBACKTIME_BF,   TSIGNTIME_BF,   CASE_SERIAL_TURN,   AREA_CODE,   CASE_MARK,   CASE_ISURGENT,   CASE_ISVISIT,   CASE_ISPUBLIC,   CASE_PROCESS_TYPE,   CASE_CONTENT,   CASE_ACCORD,   CASE_TYPE,   APPLICANT_ID,   APPLICANT_AGE,   APPLICANT_SEX,   APPLICANT_NAME,   PHONE_NUMBER,   CASE_SOURCE_DETAIL,   CASE_SOURCE,   CASE_DATE,   CASE_REGISTERNO,   CASE_REGISTER,   CASE_TITLE,   CASE_SERIAL,   ROWGUID from   (     select       ROWGUID,       END_NAME,       CASE_SOURCE,       APPLICANT_AGE,       CASE_MARK,       APPLICANT_NAME,       CASE_TITLE,       CASE_DATE,       new_case_accord,       case_accord_text,       SEND_TIME,       CASE_CONTENT,       CASE_ISVISIT,       CASE_SOURCE_DETAIL,       FINISH_TYPE,       CASE_TYPE,       AREA_CODE,       CASE_ISPUBLIC,       CASE_ADDRESS,       APPLICANT_TYPE,       CASE_EMOTION,       REQUENCY,       RELATE_SERIAL,       OPERATEDATE,       SUBJECT_RESULT_SATIFY,       PHONE_NUMBER,       APPLICANT_ID,       CASE_SERIAL,       THEME_SERIAL,       RELATION_DEPTSCODE,       CASE_REGISTERNO,       CASE_EX_ACCORD,       TFDBACKTIME_BF,       date_id,       flagguid,       flag,       FDBACKTIME,       SIGN_TIME,       CASE_GOAL,       CASE_ACCORD,       APPLICANT_SEX,       END_DEPT,       HANDLETIME_LONG,       ISKAOHE,       EVENT_DATE,       CASE_LNGLAT,       FINISH_NOTE,       CASE_PROCESS_TYPE,       CONCACT_TIME,       FINISH_TIME,       CASE_HISTORYNUM,       VISIT_TYPE,       VISIT_REMARK,       CASE_SERIAL_TURN,       OPERATEDATE1,       COMPLAINT_DETAIL,       TBACKTIME_BF,       RQSTSOURCECHILD,       ENTERPRISE_NAME,       CASE_ISURGENT,       CASE_REGISTER,       TSIGNTIME_BF,       CASE_AREA_CODE,       FDBACK,       CERTIFICATE_TYPE     from       (         select           bhb25.ROWGUID as ROWGUID,           bhb25.CASE_SERIAL as CASE_SERIAL,           bhb25.CASE_TITLE as CASE_TITLE,           bhb25.CASE_REGISTER as CASE_REGISTER,           bhb25.CASE_REGISTERNO as CASE_REGISTERNO,           bhb25.CASE_DATE as CASE_DATE,           bhb25.CASE_SOURCE as CASE_SOURCE,           bhb25.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,           bhb25.PHONE_NUMBER as PHONE_NUMBER,           bhb25.APPLICANT_NAME as APPLICANT_NAME,           bhb25.APPLICANT_SEX as APPLICANT_SEX,           bhb25.APPLICANT_AGE as APPLICANT_AGE,           bhb25.APPLICANT_ID as APPLICANT_ID,           bhb25.CASE_TYPE as CASE_TYPE,           bhb25.CASE_ACCORD as CASE_ACCORD,           bhb25.CASE_CONTENT as CASE_CONTENT,           bhb25.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,           bhb25.CASE_ISPUBLIC as CASE_ISPUBLIC,           bhb25.CASE_ISVISIT as CASE_ISVISIT,           bhb25.CASE_ISURGENT as CASE_ISURGENT,           bhb25.CASE_MARK as CASE_MARK,           bhb25.AREA_CODE as AREA_CODE,           bhb25.CASE_SERIAL_TURN as CASE_SERIAL_TURN,           bhb25.TSIGNTIME_BF as TSIGNTIME_BF,           bhb25.TFDBACKTIME_BF as TFDBACKTIME_BF,           bhb25.TBACKTIME_BF as TBACKTIME_BF,           bhb25.RELATE_SERIAL as RELATE_SERIAL,           bhb25.CASE_AREA_CODE as CASE_AREA_CODE,           bhb25.CASE_LNGLAT as CASE_LNGLAT,           bhb25.CASE_EMOTION as CASE_EMOTION,           bhb25.CASE_EX_ACCORD as CASE_EX_ACCORD,           bhb25.CASE_ADDRESS as CASE_ADDRESS,           bhb25.EVENT_DATE as EVENT_DATE,           bhb25.CASE_GOAL as CASE_GOAL,           bhb25.CERTIFICATE_TYPE as CERTIFICATE_TYPE,           bhb25.CASE_HISTORYNUM as CASE_HISTORYNUM,           bhb25.THEME_SERIAL as THEME_SERIAL,           bhb25.OPERATEDATE as OPERATEDATE,           bhb25.REQUENCY as REQUENCY,           bhb25.OPERATEDATE1 as OPERATEDATE1,           bhb25.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,           bhb25.VISIT_REMARK as VISIT_REMARK,           bhb25.VISIT_TYPE as VISIT_TYPE,           bhb25.END_DEPT as END_DEPT,           bhb25.END_NAME as END_NAME,           bhb25.CONCACT_TIME as CONCACT_TIME,           bhb25.FINISH_TIME as FINISH_TIME,           bhb25.FINISH_NOTE as FINISH_NOTE,           bhb25.FINISH_TYPE as FINISH_TYPE,           bhb25.HANDLETIME_LONG as HANDLETIME_LONG,           bhb25.SIGN_TIME as SIGN_TIME,           bhb25.FDBACKTIME as FDBACKTIME,           bhb25.SEND_TIME as SEND_TIME,           bhb25.FDBACK as FDBACK,           bhb25.flag as flag,           bhb25.flagguid as flagguid,           bhb25.ISKAOHE as ISKAOHE,           bhb25.RQSTSOURCECHILD as RQSTSOURCECHILD,           bhb25.COMPLAINT_DETAIL as COMPLAINT_DETAIL,           bhb25.APPLICANT_TYPE as APPLICANT_TYPE,           bhb25.ENTERPRISE_NAME as ENTERPRISE_NAME,           bhb25.RELATION_DEPTSCODE as RELATION_DEPTSCODE,           bhb25.case_accord_text as case_accord_text,           bhb25.new_case_accord as new_case_accord,           bhb25.date_id as date_id         from           (             select               lxzh24.date_id as date_id,               lxzh24.new_case_accord as new_case_accord,               lxzh24.case_accord_text as case_accord_text,               lxzh24.RELATION_DEPTSCODE as RELATION_DEPTSCODE,               lxzh24.ENTERPRISE_NAME as ENTERPRISE_NAME,               lxzh24.APPLICANT_TYPE as APPLICANT_TYPE,               lxzh24.COMPLAINT_DETAIL as COMPLAINT_DETAIL,               lxzh24.RQSTSOURCECHILD as RQSTSOURCECHILD,               lxzh24.ISKAOHE as ISKAOHE,               lxzh24.flagguid as flagguid,               lxzh24.flag as flag,               lxzh24.FDBACK as FDBACK,               lxzh24.SEND_TIME as SEND_TIME,               lxzh24.FDBACKTIME as FDBACKTIME,               lxzh24.SIGN_TIME as SIGN_TIME,               lxzh24.HANDLETIME_LONG as HANDLETIME_LONG,               lxzh24.FINISH_TYPE as FINISH_TYPE,               lxzh24.FINISH_NOTE as FINISH_NOTE,               lxzh24.FINISH_TIME as FINISH_TIME,               lxzh24.CONCACT_TIME as CONCACT_TIME,               lxzh24.END_NAME as END_NAME,               lxzh24.END_DEPT as END_DEPT,               lxzh24.VISIT_TYPE as VISIT_TYPE,               lxzh24.VISIT_REMARK as VISIT_REMARK,               lxzh24.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,               lxzh24.OPERATEDATE1 as OPERATEDATE1,               lxzh24.REQUENCY as REQUENCY,               lxzh24.OPERATEDATE as OPERATEDATE,               lxzh24.THEME_SERIAL as THEME_SERIAL,               lxzh24.CASE_HISTORYNUM as CASE_HISTORYNUM,               lxzh24.CERTIFICATE_TYPE as CERTIFICATE_TYPE,               lxzh24.CASE_GOAL as CASE_GOAL,               lxzh24.EVENT_DATE as EVENT_DATE,               lxzh24.CASE_ADDRESS as CASE_ADDRESS,               lxzh24.CASE_EX_ACCORD as CASE_EX_ACCORD,               lxzh24.CASE_EMOTION as CASE_EMOTION,               lxzh24.CASE_LNGLAT as CASE_LNGLAT,               lxzh24.CASE_AREA_CODE as CASE_AREA_CODE,               lxzh24.RELATE_SERIAL as RELATE_SERIAL,               lxzh24.TBACKTIME_BF as TBACKTIME_BF,               lxzh24.TFDBACKTIME_BF as TFDBACKTIME_BF,               lxzh24.TSIGNTIME_BF as TSIGNTIME_BF,               lxzh24.CASE_SERIAL_TURN as CASE_SERIAL_TURN,               lxzh24.AREA_CODE as AREA_CODE,               lxzh24.CASE_MARK as CASE_MARK,               lxzh24.CASE_ISURGENT as CASE_ISURGENT,               lxzh24.CASE_ISVISIT as CASE_ISVISIT,               lxzh24.CASE_ISPUBLIC as CASE_ISPUBLIC,               lxzh24.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,               lxzh24.CASE_CONTENT as CASE_CONTENT,               lxzh24.CASE_ACCORD as CASE_ACCORD,               lxzh24.CASE_TYPE as CASE_TYPE,               lxzh24.APPLICANT_ID as APPLICANT_ID,               lxzh24.APPLICANT_AGE as APPLICANT_AGE,               lxzh24.APPLICANT_SEX as APPLICANT_SEX,               lxzh24.APPLICANT_NAME as APPLICANT_NAME,               lxzh24.PHONE_NUMBER as PHONE_NUMBER,               lxzh24.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,               lxzh24.CASE_SOURCE as CASE_SOURCE,               lxzh24.CASE_DATE as CASE_DATE,               lxzh24.CASE_REGISTERNO as CASE_REGISTERNO,               lxzh24.CASE_REGISTER as CASE_REGISTER,               lxzh24.CASE_TITLE as CASE_TITLE,               lxzh24.CASE_SERIAL as CASE_SERIAL,               lxzh24.ROWGUID as ROWGUID             from               (                 select                   ROWGUID,                   CASE_SERIAL,                   CASE_TITLE,                   CASE_REGISTER,                   CASE_REGISTERNO,                   CASE_DATE,                   CASE_SOURCE,                   CASE_SOURCE_DETAIL,                   PHONE_NUMBER,                   APPLICANT_NAME,                   APPLICANT_SEX,                   APPLICANT_AGE,                   APPLICANT_ID,                   CASE_TYPE,                   CASE_ACCORD,                   CASE_CONTENT,                   CASE_PROCESS_TYPE,                   CASE_ISPUBLIC,                   CASE_ISVISIT,                   CASE_ISURGENT,                   CASE_MARK,                   AREA_CODE,                   CASE_SERIAL_TURN,                   TSIGNTIME_BF,                   TFDBACKTIME_BF,                   TBACKTIME_BF,                   RELATE_SERIAL,                   CASE_AREA_CODE,                   CASE_LNGLAT,                   CASE_EMOTION,                   CASE_EX_ACCORD,                   CASE_ADDRESS,                   EVENT_DATE,                   CASE_GOAL,                   CERTIFICATE_TYPE,                   CASE_HISTORYNUM,                   THEME_SERIAL,                   OPERATEDATE,                   REQUENCY,                   OPERATEDATE1,                   SUBJECT_RESULT_SATIFY,                   VISIT_TYPE,                   END_DEPT,                   END_NAME,                   CONCACT_TIME,                   FINISH_TIME,                   FINISH_NOTE,                   FINISH_TYPE,                   HANDLETIME_LONG,                   SIGN_TIME,                   FDBACKTIME,                   SEND_TIME,                   FDBACK,                   flag,                   flagguid,                   ISKAOHE,                   RQSTSOURCECHILD,                   COMPLAINT_DETAIL,                   APPLICANT_TYPE,                   ENTERPRISE_NAME,                   RELATION_DEPTSCODE,                   case_accord_text,                   new_case_accord,                   date_id,                   cast(a.VISIT_REMARK as char) as VISIT_REMARK                 from                   (                     select                       *                     from                       O_ST_XTGLB_suzhou_case_info                   ) a               ) AS lxzh24             union all             select               O_ST_XTGLB_lianyungang_case_info.date_id,               O_ST_XTGLB_lianyungang_case_info.new_case_accord,               O_ST_XTGLB_lianyungang_case_info.case_accord_text,               O_ST_XTGLB_lianyungang_case_info.RELATION_DEPTSCODE,               O_ST_XTGLB_lianyungang_case_info.ENTERPRISE_NAME,               O_ST_XTGLB_lianyungang_case_info.APPLICANT_TYPE,               O_ST_XTGLB_lianyungang_case_info.COMPLAINT_DETAIL,               O_ST_XTGLB_lianyungang_case_info.RQSTSOURCECHILD,               O_ST_XTGLB_lianyungang_case_info.ISKAOHE,               O_ST_XTGLB_lianyungang_case_info.flagguid,               O_ST_XTGLB_lianyungang_case_info.flag,               O_ST_XTGLB_lianyungang_case_info.FDBACK,               O_ST_XTGLB_lianyungang_case_info.SEND_TIME,               O_ST_XTGLB_lianyungang_case_info.FDBACKTIME,               O_ST_XTGLB_lianyungang_case_info.SIGN_TIME,               O_ST_XTGLB_lianyungang_case_info.HANDLETIME_LONG,               O_ST_XTGLB_lianyungang_case_info.FINISH_TYPE,               O_ST_XTGLB_lianyungang_case_info.FINISH_NOTE,               O_ST_XTGLB_lianyungang_case_info.FINISH_TIME,               O_ST_XTGLB_lianyungang_case_info.CONCACT_TIME,               O_ST_XTGLB_lianyungang_case_info.END_NAME,               O_ST_XTGLB_lianyungang_case_info.END_DEPT,               O_ST_XTGLB_lianyungang_case_info.VISIT_TYPE,               O_ST_XTGLB_lianyungang_case_info.VISIT_REMARK,               O_ST_XTGLB_lianyungang_case_info.SUBJECT_RESULT_SATIFY,               O_ST_XTGLB_lianyungang_case_info.OPERATEDATE1,               O_ST_XTGLB_lianyungang_case_info.REQUENCY,               O_ST_XTGLB_lianyungang_case_info.OPERATEDATE,               O_ST_XTGLB_lianyungang_case_info.THEME_SERIAL,               O_ST_XTGLB_lianyungang_case_info.CASE_HISTORYNUM,               O_ST_XTGLB_lianyungang_case_info.CERTIFICATE_TYPE,               O_ST_XTGLB_lianyungang_case_info.CASE_GOAL,               O_ST_XTGLB_lianyungang_case_info.EVENT_DATE,               O_ST_XTGLB_lianyungang_case_info.CASE_ADDRESS,               O_ST_XTGLB_lianyungang_case_info.CASE_EX_ACCORD,               O_ST_XTGLB_lianyungang_case_info.CASE_EMOTION,               O_ST_XTGLB_lianyungang_case_info.CASE_LNGLAT,               O_ST_XTGLB_lianyungang_case_info.CASE_AREA_CODE,               O_ST_XTGLB_lianyungang_case_info.RELATE_SERIAL,               O_ST_XTGLB_lianyungang_case_info.TBACKTIME_BF,               O_ST_XTGLB_lianyungang_case_info.TFDBACKTIME_BF,               O_ST_XTGLB_lianyungang_case_info.TSIGNTIME_BF,               O_ST_XTGLB_lianyungang_case_info.CASE_SERIAL_TURN,               O_ST_XTGLB_lianyungang_case_info.AREA_CODE,               O_ST_XTGLB_lianyungang_case_info.CASE_MARK,               O_ST_XTGLB_lianyungang_case_info.CASE_ISURGENT,               O_ST_XTGLB_lianyungang_case_info.CASE_ISVISIT,               O_ST_XTGLB_lianyungang_case_info.CASE_ISPUBLIC,               O_ST_XTGLB_lianyungang_case_info.CASE_PROCESS_TYPE,               O_ST_XTGLB_lianyungang_case_info.CASE_CONTENT,               O_ST_XTGLB_lianyungang_case_info.CASE_ACCORD,               O_ST_XTGLB_lianyungang_case_info.CASE_TYPE,               O_ST_XTGLB_lianyungang_case_info.APPLICANT_ID,               O_ST_XTGLB_lianyungang_case_info.APPLICANT_AGE,               O_ST_XTGLB_lianyungang_case_info.APPLICANT_SEX,               O_ST_XTGLB_lianyungang_case_info.APPLICANT_NAME,               O_ST_XTGLB_lianyungang_case_info.PHONE_NUMBER,               O_ST_XTGLB_lianyungang_case_info.CASE_SOURCE_DETAIL,               O_ST_XTGLB_lianyungang_case_info.CASE_SOURCE,               O_ST_XTGLB_lianyungang_case_info.CASE_DATE,               O_ST_XTGLB_lianyungang_case_info.CASE_REGISTERNO,               O_ST_XTGLB_lianyungang_case_info.CASE_REGISTER,               O_ST_XTGLB_lianyungang_case_info.CASE_TITLE,               O_ST_XTGLB_lianyungang_case_info.CASE_SERIAL,               O_ST_XTGLB_lianyungang_case_info.ROWGUID             from               (                 select                   *                 from                   O_ST_XTGLB_lianyungang_case_info               ) AS O_ST_XTGLB_lianyungang_case_info           ) AS bhb25         union all         select           bhb23.ROWGUID,           bhb23.CASE_SERIAL,           bhb23.CASE_TITLE,           bhb23.CASE_REGISTER,           bhb23.CASE_REGISTERNO,           bhb23.CASE_DATE,           bhb23.CASE_SOURCE,           bhb23.CASE_SOURCE_DETAIL,           bhb23.PHONE_NUMBER,           bhb23.APPLICANT_NAME,           bhb23.APPLICANT_SEX,           bhb23.APPLICANT_AGE,           bhb23.APPLICANT_ID,           bhb23.CASE_TYPE,           bhb23.CASE_ACCORD,           bhb23.CASE_CONTENT,           bhb23.CASE_PROCESS_TYPE,           bhb23.CASE_ISPUBLIC,           bhb23.CASE_ISVISIT,           bhb23.CASE_ISURGENT,           bhb23.CASE_MARK,           bhb23.AREA_CODE,           bhb23.CASE_SERIAL_TURN,           bhb23.TSIGNTIME_BF,           bhb23.TFDBACKTIME_BF,           bhb23.TBACKTIME_BF,           bhb23.RELATE_SERIAL,           bhb23.CASE_AREA_CODE,           bhb23.CASE_LNGLAT,           bhb23.CASE_EMOTION,           bhb23.CASE_EX_ACCORD,           bhb23.CASE_ADDRESS,           bhb23.EVENT_DATE,           bhb23.CASE_GOAL,           bhb23.CERTIFICATE_TYPE,           bhb23.CASE_HISTORYNUM,           bhb23.THEME_SERIAL,           bhb23.OPERATEDATE,           bhb23.REQUENCY,           bhb23.OPERATEDATE1,           bhb23.SUBJECT_RESULT_SATIFY,           bhb23.VISIT_REMARK,           bhb23.VISIT_TYPE,           bhb23.END_DEPT,           bhb23.END_NAME,           bhb23.CONCACT_TIME,           bhb23.FINISH_TIME,           bhb23.FINISH_NOTE,           bhb23.FINISH_TYPE,           bhb23.HANDLETIME_LONG,           bhb23.SIGN_TIME,           bhb23.FDBACKTIME,           bhb23.SEND_TIME,           bhb23.FDBACK,           bhb23.flag,           bhb23.flagguid,           bhb23.ISKAOHE,           bhb23.RQSTSOURCECHILD,           bhb23.COMPLAINT_DETAIL,           bhb23.APPLICANT_TYPE,           bhb23.ENTERPRISE_NAME,           bhb23.RELATION_DEPTSCODE,           bhb23.case_accord_text,           bhb23.new_case_accord,           bhb23.date_id         from           (             select               bhb19.date_id as date_id,               bhb19.new_case_accord as new_case_accord,               bhb19.case_accord_text as case_accord_text,               bhb19.RELATION_DEPTS as RELATION_DEPTS,               bhb19.RELATION_DEPTSCODE as RELATION_DEPTSCODE,               bhb19.ENTERPRISE_NAME as ENTERPRISE_NAME,               bhb19.APPLICANT_TYPE as APPLICANT_TYPE,               bhb19.COMPLAINT_DETAIL as COMPLAINT_DETAIL,               bhb19.RQSTSOURCECHILD as RQSTSOURCECHILD,               bhb19.ISKAOHE as ISKAOHE,               bhb19.flagguid as flagguid,               bhb19.flag as flag,               bhb19.FDBACK as FDBACK,               bhb19.SEND_TIME as SEND_TIME,               bhb19.FDBACKTIME as FDBACKTIME,               bhb19.SIGN_TIME as SIGN_TIME,               bhb19.HANDLETIME_LONG as HANDLETIME_LONG,               bhb19.FINISH_TYPE as FINISH_TYPE,               bhb19.FINISH_NOTE as FINISH_NOTE,               bhb19.FINISH_TIME as FINISH_TIME,               bhb19.CONCACT_TIME as CONCACT_TIME,               bhb19.END_NAME as END_NAME,               bhb19.END_DEPT as END_DEPT,               bhb19.VISIT_TYPE as VISIT_TYPE,               bhb19.VISIT_REMARK as VISIT_REMARK,               bhb19.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,               bhb19.OPERATEDATE1 as OPERATEDATE1,               bhb19.REQUENCY as REQUENCY,               bhb19.OPERATEDATE as OPERATEDATE,               bhb19.THEME_SERIAL as THEME_SERIAL,               bhb19.CASE_HISTORYNUM as CASE_HISTORYNUM,               bhb19.CERTIFICATE_TYPE as CERTIFICATE_TYPE,               bhb19.CASE_GOAL as CASE_GOAL,               bhb19.EVENT_DATE as EVENT_DATE,               bhb19.CASE_ADDRESS as CASE_ADDRESS,               bhb19.CASE_EX_ACCORD as CASE_EX_ACCORD,               bhb19.CASE_EMOTION as CASE_EMOTION,               bhb19.CASE_LNGLAT as CASE_LNGLAT,               bhb19.CASE_AREA_CODE as CASE_AREA_CODE,               bhb19.RELATE_SERIAL as RELATE_SERIAL,               bhb19.TBACKTIME_BF as TBACKTIME_BF,               bhb19.TFDBACKTIME_BF as TFDBACKTIME_BF,               bhb19.TSIGNTIME_BF as TSIGNTIME_BF,               bhb19.CASE_SERIAL_TURN as CASE_SERIAL_TURN,               bhb19.AREA_CODE as AREA_CODE,               bhb19.CASE_MARK as CASE_MARK,               bhb19.CASE_ISURGENT as CASE_ISURGENT,               bhb19.CASE_ISVISIT as CASE_ISVISIT,               bhb19.CASE_ISPUBLIC as CASE_ISPUBLIC,               bhb19.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,               bhb19.CASE_CONTENT as CASE_CONTENT,               bhb19.CASE_ACCORD as CASE_ACCORD,               bhb19.CASE_TYPE as CASE_TYPE,               bhb19.APPLICANT_ID as APPLICANT_ID,               bhb19.APPLICANT_AGE as APPLICANT_AGE,               bhb19.APPLICANT_SEX as APPLICANT_SEX,               bhb19.APPLICANT_NAME as APPLICANT_NAME,               bhb19.PHONE_NUMBER as PHONE_NUMBER,               bhb19.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,               bhb19.CASE_SOURCE as CASE_SOURCE,               bhb19.CASE_DATE as CASE_DATE,               bhb19.CASE_REGISTERNO as CASE_REGISTERNO,               bhb19.CASE_REGISTER as CASE_REGISTER,               bhb19.CASE_TITLE as CASE_TITLE,               bhb19.CASE_SERIAL as CASE_SERIAL,               bhb19.ROWGUID as ROWGUID             from               (                 select                   bhb17.ROWGUID as ROWGUID,                   bhb17.CASE_SERIAL as CASE_SERIAL,                   bhb17.CASE_TITLE as CASE_TITLE,                   bhb17.CASE_REGISTER as CASE_REGISTER,                   bhb17.CASE_REGISTERNO as CASE_REGISTERNO,                   bhb17.CASE_DATE as CASE_DATE,                   bhb17.CASE_SOURCE as CASE_SOURCE,                   bhb17.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                   bhb17.PHONE_NUMBER as PHONE_NUMBER,                   bhb17.APPLICANT_NAME as APPLICANT_NAME,                   bhb17.APPLICANT_SEX as APPLICANT_SEX,                   bhb17.APPLICANT_AGE as APPLICANT_AGE,                   bhb17.APPLICANT_ID as APPLICANT_ID,                   bhb17.CASE_TYPE as CASE_TYPE,                   bhb17.CASE_ACCORD as CASE_ACCORD,                   bhb17.CASE_CONTENT as CASE_CONTENT,                   bhb17.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                   bhb17.CASE_ISPUBLIC as CASE_ISPUBLIC,                   bhb17.CASE_ISVISIT as CASE_ISVISIT,                   bhb17.CASE_ISURGENT as CASE_ISURGENT,                   bhb17.CASE_MARK as CASE_MARK,                   bhb17.AREA_CODE as AREA_CODE,                   bhb17.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                   bhb17.TSIGNTIME_BF as TSIGNTIME_BF,                   bhb17.TFDBACKTIME_BF as TFDBACKTIME_BF,                   bhb17.TBACKTIME_BF as TBACKTIME_BF,                   bhb17.RELATE_SERIAL as RELATE_SERIAL,                   bhb17.CASE_AREA_CODE as CASE_AREA_CODE,                   bhb17.CASE_LNGLAT as CASE_LNGLAT,                   bhb17.CASE_EMOTION as CASE_EMOTION,                   bhb17.CASE_EX_ACCORD as CASE_EX_ACCORD,                   bhb17.CASE_ADDRESS as CASE_ADDRESS,                   bhb17.EVENT_DATE as EVENT_DATE,                   bhb17.CASE_GOAL as CASE_GOAL,                   bhb17.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                   bhb17.CASE_HISTORYNUM as CASE_HISTORYNUM,                   bhb17.THEME_SERIAL as THEME_SERIAL,                   bhb17.OPERATEDATE as OPERATEDATE,                   bhb17.REQUENCY as REQUENCY,                   bhb17.OPERATEDATE1 as OPERATEDATE1,                   bhb17.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                   bhb17.VISIT_REMARK as VISIT_REMARK,                   bhb17.VISIT_TYPE as VISIT_TYPE,                   bhb17.END_DEPT as END_DEPT,                   bhb17.END_NAME as END_NAME,                   bhb17.CONCACT_TIME as CONCACT_TIME,                   bhb17.FINISH_TIME as FINISH_TIME,                   bhb17.FINISH_NOTE as FINISH_NOTE,                   bhb17.FINISH_TYPE as FINISH_TYPE,                   bhb17.HANDLETIME_LONG as HANDLETIME_LONG,                   bhb17.SIGN_TIME as SIGN_TIME,                   bhb17.FDBACKTIME as FDBACKTIME,                   bhb17.SEND_TIME as SEND_TIME,                   bhb17.FDBACK as FDBACK,                   bhb17.flag as flag,                   bhb17.flagguid as flagguid,                   bhb17.ISKAOHE as ISKAOHE,                   bhb17.RQSTSOURCECHILD as RQSTSOURCECHILD,                   bhb17.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                   bhb17.APPLICANT_TYPE as APPLICANT_TYPE,                   bhb17.ENTERPRISE_NAME as ENTERPRISE_NAME,                   bhb17.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                   bhb17.RELATION_DEPTS as RELATION_DEPTS,                   bhb17.RELATION_POLICE_OFFICER as RELATION_POLICE_OFFICER,                   bhb17.case_accord_text as case_accord_text,                   bhb17.new_case_accord as new_case_accord,                   bhb17.date_id as date_id                 from                   (                     select                       O_ST_XTGLB_yancheng_case_info.date_id as date_id,                       O_ST_XTGLB_yancheng_case_info.new_case_accord as new_case_accord,                       O_ST_XTGLB_yancheng_case_info.case_accord_text as case_accord_text,                       O_ST_XTGLB_yancheng_case_info.RELATION_POLICE_OFFICER as RELATION_POLICE_OFFICER,                       O_ST_XTGLB_yancheng_case_info.RELATION_DEPTS as RELATION_DEPTS,                       O_ST_XTGLB_yancheng_case_info.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                       O_ST_XTGLB_yancheng_case_info.ENTERPRISE_NAME as ENTERPRISE_NAME,                       O_ST_XTGLB_yancheng_case_info.APPLICANT_TYPE as APPLICANT_TYPE,                       O_ST_XTGLB_yancheng_case_info.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                       O_ST_XTGLB_yancheng_case_info.RQSTSOURCECHILD as RQSTSOURCECHILD,                       O_ST_XTGLB_yancheng_case_info.ISKAOHE as ISKAOHE,                       O_ST_XTGLB_yancheng_case_info.flagguid as flagguid,                       O_ST_XTGLB_yancheng_case_info.flag as flag,                       O_ST_XTGLB_yancheng_case_info.FDBACK as FDBACK,                       O_ST_XTGLB_yancheng_case_info.SEND_TIME as SEND_TIME,                       O_ST_XTGLB_yancheng_case_info.FDBACKTIME as FDBACKTIME,                       O_ST_XTGLB_yancheng_case_info.SIGN_TIME as SIGN_TIME,                       O_ST_XTGLB_yancheng_case_info.HANDLETIME_LONG as HANDLETIME_LONG,                       O_ST_XTGLB_yancheng_case_info.FINISH_TYPE as FINISH_TYPE,                       O_ST_XTGLB_yancheng_case_info.FINISH_NOTE as FINISH_NOTE,                       O_ST_XTGLB_yancheng_case_info.FINISH_TIME as FINISH_TIME,                       O_ST_XTGLB_yancheng_case_info.CONCACT_TIME as CONCACT_TIME,                       O_ST_XTGLB_yancheng_case_info.END_NAME as END_NAME,                       O_ST_XTGLB_yancheng_case_info.END_DEPT as END_DEPT,                       O_ST_XTGLB_yancheng_case_info.VISIT_TYPE as VISIT_TYPE,                       O_ST_XTGLB_yancheng_case_info.VISIT_REMARK as VISIT_REMARK,                       O_ST_XTGLB_yancheng_case_info.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                       O_ST_XTGLB_yancheng_case_info.OPERATEDATE1 as OPERATEDATE1,                       O_ST_XTGLB_yancheng_case_info.REQUENCY as REQUENCY,                       O_ST_XTGLB_yancheng_case_info.OPERATEDATE as OPERATEDATE,                       O_ST_XTGLB_yancheng_case_info.THEME_SERIAL as THEME_SERIAL,                       O_ST_XTGLB_yancheng_case_info.CASE_HISTORYNUM as CASE_HISTORYNUM,                       O_ST_XTGLB_yancheng_case_info.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                       O_ST_XTGLB_yancheng_case_info.CASE_GOAL as CASE_GOAL,                       O_ST_XTGLB_yancheng_case_info.EVENT_DATE as EVENT_DATE,                       O_ST_XTGLB_yancheng_case_info.CASE_ADDRESS as CASE_ADDRESS,                       O_ST_XTGLB_yancheng_case_info.CASE_EX_ACCORD as CASE_EX_ACCORD,                       O_ST_XTGLB_yancheng_case_info.CASE_EMOTION as CASE_EMOTION,                       O_ST_XTGLB_yancheng_case_info.CASE_LNGLAT as CASE_LNGLAT,                       O_ST_XTGLB_yancheng_case_info.CASE_AREA_CODE as CASE_AREA_CODE,                       O_ST_XTGLB_yancheng_case_info.RELATE_SERIAL as RELATE_SERIAL,                       O_ST_XTGLB_yancheng_case_info.TBACKTIME_BF as TBACKTIME_BF,                       O_ST_XTGLB_yancheng_case_info.TFDBACKTIME_BF as TFDBACKTIME_BF,                       O_ST_XTGLB_yancheng_case_info.TSIGNTIME_BF as TSIGNTIME_BF,                       O_ST_XTGLB_yancheng_case_info.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                       O_ST_XTGLB_yancheng_case_info.AREA_CODE as AREA_CODE,                       O_ST_XTGLB_yancheng_case_info.CASE_MARK as CASE_MARK,                       O_ST_XTGLB_yancheng_case_info.CASE_ISURGENT as CASE_ISURGENT,                       O_ST_XTGLB_yancheng_case_info.CASE_ISVISIT as CASE_ISVISIT,                       O_ST_XTGLB_yancheng_case_info.CASE_ISPUBLIC as CASE_ISPUBLIC,                       O_ST_XTGLB_yancheng_case_info.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                       O_ST_XTGLB_yancheng_case_info.CASE_CONTENT as CASE_CONTENT,                       O_ST_XTGLB_yancheng_case_info.CASE_ACCORD as CASE_ACCORD,                       O_ST_XTGLB_yancheng_case_info.CASE_TYPE as CASE_TYPE,                       O_ST_XTGLB_yancheng_case_info.APPLICANT_ID as APPLICANT_ID,                       O_ST_XTGLB_yancheng_case_info.APPLICANT_AGE as APPLICANT_AGE,                       O_ST_XTGLB_yancheng_case_info.APPLICANT_SEX as APPLICANT_SEX,                       O_ST_XTGLB_yancheng_case_info.APPLICANT_NAME as APPLICANT_NAME,                       O_ST_XTGLB_yancheng_case_info.PHONE_NUMBER as PHONE_NUMBER,                       O_ST_XTGLB_yancheng_case_info.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                       O_ST_XTGLB_yancheng_case_info.CASE_SOURCE as CASE_SOURCE,                       O_ST_XTGLB_yancheng_case_info.CASE_DATE as CASE_DATE,                       O_ST_XTGLB_yancheng_case_info.CASE_REGISTERNO as CASE_REGISTERNO,                       O_ST_XTGLB_yancheng_case_info.CASE_REGISTER as CASE_REGISTER,                       O_ST_XTGLB_yancheng_case_info.CASE_TITLE as CASE_TITLE,                       O_ST_XTGLB_yancheng_case_info.CASE_SERIAL as CASE_SERIAL,                       O_ST_XTGLB_yancheng_case_info.ROWGUID as ROWGUID                     from                       (                         select                           *                         from                           O_ST_XTGLB_yancheng_case_info                       ) AS O_ST_XTGLB_yancheng_case_info                     union all                     select                       O_ST_XTGLB_taizhou_case_info.date_id,                       O_ST_XTGLB_taizhou_case_info.new_case_accord,                       O_ST_XTGLB_taizhou_case_info.case_accord_text,                       O_ST_XTGLB_taizhou_case_info.RELATION_POLICE_OFFICER,                       O_ST_XTGLB_taizhou_case_info.RELATION_DEPTS,                       O_ST_XTGLB_taizhou_case_info.RELATION_DEPTSCODE,                       O_ST_XTGLB_taizhou_case_info.ENTERPRISE_NAME,                       O_ST_XTGLB_taizhou_case_info.APPLICANT_TYPE,                       O_ST_XTGLB_taizhou_case_info.COMPLAINT_DETAIL,                       O_ST_XTGLB_taizhou_case_info.RQSTSOURCECHILD,                       O_ST_XTGLB_taizhou_case_info.ISKAOHE,                       O_ST_XTGLB_taizhou_case_info.flagguid,                       O_ST_XTGLB_taizhou_case_info.flag,                       O_ST_XTGLB_taizhou_case_info.FDBACK,                       O_ST_XTGLB_taizhou_case_info.SEND_TIME,                       O_ST_XTGLB_taizhou_case_info.FDBACKTIME,                       O_ST_XTGLB_taizhou_case_info.SIGN_TIME,                       O_ST_XTGLB_taizhou_case_info.HANDLETIME_LONG,                       O_ST_XTGLB_taizhou_case_info.FINISH_TYPE,                       O_ST_XTGLB_taizhou_case_info.FINISH_NOTE,                       O_ST_XTGLB_taizhou_case_info.FINISH_TIME,                       O_ST_XTGLB_taizhou_case_info.CONCACT_TIME,                       O_ST_XTGLB_taizhou_case_info.END_NAME,                       O_ST_XTGLB_taizhou_case_info.END_DEPT,                       O_ST_XTGLB_taizhou_case_info.VISIT_TYPE,                       O_ST_XTGLB_taizhou_case_info.VISIT_REMARK,                       O_ST_XTGLB_taizhou_case_info.SUBJECT_RESULT_SATIFY,                       O_ST_XTGLB_taizhou_case_info.OPERATEDATE1,                       O_ST_XTGLB_taizhou_case_info.REQUENCY,                       O_ST_XTGLB_taizhou_case_info.OPERATEDATE,                       O_ST_XTGLB_taizhou_case_info.THEME_SERIAL,                       O_ST_XTGLB_taizhou_case_info.CASE_HISTORYNUM,                       O_ST_XTGLB_taizhou_case_info.CERTIFICATE_TYPE,                       O_ST_XTGLB_taizhou_case_info.CASE_GOAL,                       O_ST_XTGLB_taizhou_case_info.EVENT_DATE,                       O_ST_XTGLB_taizhou_case_info.CASE_ADDRESS,                       O_ST_XTGLB_taizhou_case_info.CASE_EX_ACCORD,                       O_ST_XTGLB_taizhou_case_info.CASE_EMOTION,                       O_ST_XTGLB_taizhou_case_info.CASE_LNGLAT,                       O_ST_XTGLB_taizhou_case_info.CASE_AREA_CODE,                       O_ST_XTGLB_taizhou_case_info.RELATE_SERIAL,                       O_ST_XTGLB_taizhou_case_info.TBACKTIME_BF,                       O_ST_XTGLB_taizhou_case_info.TFDBACKTIME_BF,                       O_ST_XTGLB_taizhou_case_info.TSIGNTIME_BF,                       O_ST_XTGLB_taizhou_case_info.CASE_SERIAL_TURN,                       O_ST_XTGLB_taizhou_case_info.AREA_CODE,                       O_ST_XTGLB_taizhou_case_info.CASE_MARK,                       O_ST_XTGLB_taizhou_case_info.CASE_ISURGENT,                       O_ST_XTGLB_taizhou_case_info.CASE_ISVISIT,                       O_ST_XTGLB_taizhou_case_info.CASE_ISPUBLIC,                       O_ST_XTGLB_taizhou_case_info.CASE_PROCESS_TYPE,                       O_ST_XTGLB_taizhou_case_info.CASE_CONTENT,                       O_ST_XTGLB_taizhou_case_info.CASE_ACCORD,                       O_ST_XTGLB_taizhou_case_info.CASE_TYPE,                       O_ST_XTGLB_taizhou_case_info.APPLICANT_ID,                       O_ST_XTGLB_taizhou_case_info.APPLICANT_AGE,                       O_ST_XTGLB_taizhou_case_info.APPLICANT_SEX,                       O_ST_XTGLB_taizhou_case_info.APPLICANT_NAME,                       O_ST_XTGLB_taizhou_case_info.PHONE_NUMBER,                       O_ST_XTGLB_taizhou_case_info.CASE_SOURCE_DETAIL,                       O_ST_XTGLB_taizhou_case_info.CASE_SOURCE,                       O_ST_XTGLB_taizhou_case_info.CASE_DATE,                       O_ST_XTGLB_taizhou_case_info.CASE_REGISTERNO,                       O_ST_XTGLB_taizhou_case_info.CASE_REGISTER,                       O_ST_XTGLB_taizhou_case_info.CASE_TITLE,                       O_ST_XTGLB_taizhou_case_info.CASE_SERIAL,                       O_ST_XTGLB_taizhou_case_info.ROWGUID                     from                       (                         select                           *                         from                           O_ST_XTGLB_taizhou_case_info                       ) AS O_ST_XTGLB_taizhou_case_info                   ) AS bhb17                 union all                 select                   bhb18.ROWGUID,                   bhb18.CASE_SERIAL,                   bhb18.CASE_TITLE,                   bhb18.CASE_REGISTER,                   bhb18.CASE_REGISTERNO,                   bhb18.CASE_DATE,                   bhb18.CASE_SOURCE,                   bhb18.CASE_SOURCE_DETAIL,                   bhb18.PHONE_NUMBER,                   bhb18.APPLICANT_NAME,                   bhb18.APPLICANT_SEX,                   bhb18.APPLICANT_AGE,                   bhb18.APPLICANT_ID,                   bhb18.CASE_TYPE,                   bhb18.CASE_ACCORD,                   bhb18.CASE_CONTENT,                   bhb18.CASE_PROCESS_TYPE,                   bhb18.CASE_ISPUBLIC,                   bhb18.CASE_ISVISIT,                   bhb18.CASE_ISURGENT,                   bhb18.CASE_MARK,                   bhb18.AREA_CODE,                   bhb18.CASE_SERIAL_TURN,                   bhb18.TSIGNTIME_BF,                   bhb18.TFDBACKTIME_BF,                   bhb18.TBACKTIME_BF,                   bhb18.RELATE_SERIAL,                   bhb18.CASE_AREA_CODE,                   bhb18.CASE_LNGLAT,                   bhb18.CASE_EMOTION,                   bhb18.CASE_EX_ACCORD,                   bhb18.CASE_ADDRESS,                   bhb18.EVENT_DATE,                   bhb18.CASE_GOAL,                   bhb18.CERTIFICATE_TYPE,                   bhb18.CASE_HISTORYNUM,                   bhb18.THEME_SERIAL,                   bhb18.OPERATEDATE,                   bhb18.REQUENCY,                   bhb18.OPERATEDATE1,                   bhb18.SUBJECT_RESULT_SATIFY,                   bhb18.VISIT_REMARK,                   bhb18.VISIT_TYPE,                   bhb18.END_DEPT,                   bhb18.END_NAME,                   bhb18.CONCACT_TIME,                   bhb18.FINISH_TIME,                   bhb18.FINISH_NOTE,                   bhb18.FINISH_TYPE,                   bhb18.HANDLETIME_LONG,                   bhb18.SIGN_TIME,                   bhb18.FDBACKTIME,                   bhb18.SEND_TIME,                   bhb18.FDBACK,                   bhb18.flag,                   bhb18.flagguid,                   bhb18.ISKAOHE,                   bhb18.RQSTSOURCECHILD,                   bhb18.COMPLAINT_DETAIL,                   bhb18.APPLICANT_TYPE,                   bhb18.ENTERPRISE_NAME,                   bhb18.RELATION_DEPTSCODE,                   bhb18.RELATION_DEPTS,                   bhb18.RELATION_POLICE_OFFICER,                   bhb18.case_accord_text,                   bhb18.new_case_accord,                   bhb18.date_id                 from                   (                     select                       O_ST_XTGLB_xuzhou_case_info.date_id as date_id,                       O_ST_XTGLB_xuzhou_case_info.new_case_accord as new_case_accord,                       O_ST_XTGLB_xuzhou_case_info.case_accord_text as case_accord_text,                       O_ST_XTGLB_xuzhou_case_info.RELATION_POLICE_OFFICER as RELATION_POLICE_OFFICER,                       O_ST_XTGLB_xuzhou_case_info.RELATION_DEPTS as RELATION_DEPTS,                       O_ST_XTGLB_xuzhou_case_info.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                       O_ST_XTGLB_xuzhou_case_info.ENTERPRISE_NAME as ENTERPRISE_NAME,                       O_ST_XTGLB_xuzhou_case_info.APPLICANT_TYPE as APPLICANT_TYPE,                       O_ST_XTGLB_xuzhou_case_info.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                       O_ST_XTGLB_xuzhou_case_info.RQSTSOURCECHILD as RQSTSOURCECHILD,                       O_ST_XTGLB_xuzhou_case_info.ISKAOHE as ISKAOHE,                       O_ST_XTGLB_xuzhou_case_info.flagguid as flagguid,                       O_ST_XTGLB_xuzhou_case_info.flag as flag,                       O_ST_XTGLB_xuzhou_case_info.FDBACK as FDBACK,                       O_ST_XTGLB_xuzhou_case_info.SEND_TIME as SEND_TIME,                       O_ST_XTGLB_xuzhou_case_info.FDBACKTIME as FDBACKTIME,                       O_ST_XTGLB_xuzhou_case_info.SIGN_TIME as SIGN_TIME,                       O_ST_XTGLB_xuzhou_case_info.HANDLETIME_LONG as HANDLETIME_LONG,                       O_ST_XTGLB_xuzhou_case_info.FINISH_TYPE as FINISH_TYPE,                       O_ST_XTGLB_xuzhou_case_info.FINISH_NOTE as FINISH_NOTE,                       O_ST_XTGLB_xuzhou_case_info.FINISH_TIME as FINISH_TIME,                       O_ST_XTGLB_xuzhou_case_info.CONCACT_TIME as CONCACT_TIME,                       O_ST_XTGLB_xuzhou_case_info.END_NAME as END_NAME,                       O_ST_XTGLB_xuzhou_case_info.END_DEPT as END_DEPT,                       O_ST_XTGLB_xuzhou_case_info.VISIT_TYPE as VISIT_TYPE,                       O_ST_XTGLB_xuzhou_case_info.VISIT_REMARK as VISIT_REMARK,                       O_ST_XTGLB_xuzhou_case_info.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                       O_ST_XTGLB_xuzhou_case_info.OPERATEDATE1 as OPERATEDATE1,                       O_ST_XTGLB_xuzhou_case_info.REQUENCY as REQUENCY,                       O_ST_XTGLB_xuzhou_case_info.OPERATEDATE as OPERATEDATE,                       O_ST_XTGLB_xuzhou_case_info.THEME_SERIAL as THEME_SERIAL,                       O_ST_XTGLB_xuzhou_case_info.CASE_HISTORYNUM as CASE_HISTORYNUM,                       O_ST_XTGLB_xuzhou_case_info.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                       O_ST_XTGLB_xuzhou_case_info.CASE_GOAL as CASE_GOAL,                       O_ST_XTGLB_xuzhou_case_info.EVENT_DATE as EVENT_DATE,                       O_ST_XTGLB_xuzhou_case_info.CASE_ADDRESS as CASE_ADDRESS,                       O_ST_XTGLB_xuzhou_case_info.CASE_EX_ACCORD as CASE_EX_ACCORD,                       O_ST_XTGLB_xuzhou_case_info.CASE_EMOTION as CASE_EMOTION,                       O_ST_XTGLB_xuzhou_case_info.CASE_LNGLAT as CASE_LNGLAT,                       O_ST_XTGLB_xuzhou_case_info.CASE_AREA_CODE as CASE_AREA_CODE,                       O_ST_XTGLB_xuzhou_case_info.RELATE_SERIAL as RELATE_SERIAL,                       O_ST_XTGLB_xuzhou_case_info.TBACKTIME_BF as TBACKTIME_BF,                       O_ST_XTGLB_xuzhou_case_info.TFDBACKTIME_BF as TFDBACKTIME_BF,                       O_ST_XTGLB_xuzhou_case_info.TSIGNTIME_BF as TSIGNTIME_BF,                       O_ST_XTGLB_xuzhou_case_info.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                       O_ST_XTGLB_xuzhou_case_info.AREA_CODE as AREA_CODE,                       O_ST_XTGLB_xuzhou_case_info.CASE_MARK as CASE_MARK,                       O_ST_XTGLB_xuzhou_case_info.CASE_ISURGENT as CASE_ISURGENT,                       O_ST_XTGLB_xuzhou_case_info.CASE_ISVISIT as CASE_ISVISIT,                       O_ST_XTGLB_xuzhou_case_info.CASE_ISPUBLIC as CASE_ISPUBLIC,                       O_ST_XTGLB_xuzhou_case_info.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                       O_ST_XTGLB_xuzhou_case_info.CASE_CONTENT as CASE_CONTENT,                       O_ST_XTGLB_xuzhou_case_info.CASE_ACCORD as CASE_ACCORD,                       O_ST_XTGLB_xuzhou_case_info.CASE_TYPE as CASE_TYPE,                       O_ST_XTGLB_xuzhou_case_info.APPLICANT_ID as APPLICANT_ID,                       O_ST_XTGLB_xuzhou_case_info.APPLICANT_AGE as APPLICANT_AGE,                       O_ST_XTGLB_xuzhou_case_info.APPLICANT_SEX as APPLICANT_SEX,                       O_ST_XTGLB_xuzhou_case_info.APPLICANT_NAME as APPLICANT_NAME,                       O_ST_XTGLB_xuzhou_case_info.PHONE_NUMBER as PHONE_NUMBER,                       O_ST_XTGLB_xuzhou_case_info.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                       O_ST_XTGLB_xuzhou_case_info.CASE_SOURCE as CASE_SOURCE,                       O_ST_XTGLB_xuzhou_case_info.CASE_DATE as CASE_DATE,                       O_ST_XTGLB_xuzhou_case_info.CASE_REGISTERNO as CASE_REGISTERNO,                       O_ST_XTGLB_xuzhou_case_info.CASE_REGISTER as CASE_REGISTER,                       O_ST_XTGLB_xuzhou_case_info.CASE_TITLE as CASE_TITLE,                       O_ST_XTGLB_xuzhou_case_info.CASE_SERIAL as CASE_SERIAL,                       O_ST_XTGLB_xuzhou_case_info.ROWGUID as ROWGUID                     from                       (                         select                           *                         from                           O_ST_XTGLB_xuzhou_case_info                       ) AS O_ST_XTGLB_xuzhou_case_info                     union all                     select                       O_ST_XTGLB_suqian_case_info.date_id,                       O_ST_XTGLB_suqian_case_info.new_case_accord,                       O_ST_XTGLB_suqian_case_info.case_accord_text,                       O_ST_XTGLB_suqian_case_info.RELATION_POLICE_OFFICER,                       O_ST_XTGLB_suqian_case_info.RELATION_DEPTS,                       O_ST_XTGLB_suqian_case_info.RELATION_DEPTSCODE,                       O_ST_XTGLB_suqian_case_info.ENTERPRISE_NAME,                       O_ST_XTGLB_suqian_case_info.APPLICANT_TYPE,                       O_ST_XTGLB_suqian_case_info.COMPLAINT_DETAIL,                       O_ST_XTGLB_suqian_case_info.RQSTSOURCECHILD,                       O_ST_XTGLB_suqian_case_info.ISKAOHE,                       O_ST_XTGLB_suqian_case_info.flagguid,                       O_ST_XTGLB_suqian_case_info.flag,                       O_ST_XTGLB_suqian_case_info.FDBACK,                       O_ST_XTGLB_suqian_case_info.SEND_TIME,                       O_ST_XTGLB_suqian_case_info.FDBACKTIME,                       O_ST_XTGLB_suqian_case_info.SIGN_TIME,                       O_ST_XTGLB_suqian_case_info.HANDLETIME_LONG,                       O_ST_XTGLB_suqian_case_info.FINISH_TYPE,                       O_ST_XTGLB_suqian_case_info.FINISH_NOTE,                       O_ST_XTGLB_suqian_case_info.FINISH_TIME,                       O_ST_XTGLB_suqian_case_info.CONCACT_TIME,                       O_ST_XTGLB_suqian_case_info.END_NAME,                       O_ST_XTGLB_suqian_case_info.END_DEPT,                       O_ST_XTGLB_suqian_case_info.VISIT_TYPE,                       O_ST_XTGLB_suqian_case_info.VISIT_REMARK,                       O_ST_XTGLB_suqian_case_info.SUBJECT_RESULT_SATIFY,                       O_ST_XTGLB_suqian_case_info.OPERATEDATE1,                       O_ST_XTGLB_suqian_case_info.REQUENCY,                       O_ST_XTGLB_suqian_case_info.OPERATEDATE,                       O_ST_XTGLB_suqian_case_info.THEME_SERIAL,                       O_ST_XTGLB_suqian_case_info.CASE_HISTORYNUM,                       O_ST_XTGLB_suqian_case_info.CERTIFICATE_TYPE,                       O_ST_XTGLB_suqian_case_info.CASE_GOAL,                       O_ST_XTGLB_suqian_case_info.EVENT_DATE,                       O_ST_XTGLB_suqian_case_info.CASE_ADDRESS,                       O_ST_XTGLB_suqian_case_info.CASE_EX_ACCORD,                       O_ST_XTGLB_suqian_case_info.CASE_EMOTION,                       O_ST_XTGLB_suqian_case_info.CASE_LNGLAT,                       O_ST_XTGLB_suqian_case_info.CASE_AREA_CODE,                       O_ST_XTGLB_suqian_case_info.RELATE_SERIAL,                       O_ST_XTGLB_suqian_case_info.TBACKTIME_BF,                       O_ST_XTGLB_suqian_case_info.TFDBACKTIME_BF,                       O_ST_XTGLB_suqian_case_info.TSIGNTIME_BF,                       O_ST_XTGLB_suqian_case_info.CASE_SERIAL_TURN,                       O_ST_XTGLB_suqian_case_info.AREA_CODE,                       O_ST_XTGLB_suqian_case_info.CASE_MARK,                       O_ST_XTGLB_suqian_case_info.CASE_ISURGENT,                       O_ST_XTGLB_suqian_case_info.CASE_ISVISIT,                       O_ST_XTGLB_suqian_case_info.CASE_ISPUBLIC,                       O_ST_XTGLB_suqian_case_info.CASE_PROCESS_TYPE,                       O_ST_XTGLB_suqian_case_info.CASE_CONTENT,                       O_ST_XTGLB_suqian_case_info.CASE_ACCORD,                       O_ST_XTGLB_suqian_case_info.CASE_TYPE,                       O_ST_XTGLB_suqian_case_info.APPLICANT_ID,                       O_ST_XTGLB_suqian_case_info.APPLICANT_AGE,                       O_ST_XTGLB_suqian_case_info.APPLICANT_SEX,                       O_ST_XTGLB_suqian_case_info.APPLICANT_NAME,                       O_ST_XTGLB_suqian_case_info.PHONE_NUMBER,                       O_ST_XTGLB_suqian_case_info.CASE_SOURCE_DETAIL,                       O_ST_XTGLB_suqian_case_info.CASE_SOURCE,                       O_ST_XTGLB_suqian_case_info.CASE_DATE,                       O_ST_XTGLB_suqian_case_info.CASE_REGISTERNO,                       O_ST_XTGLB_suqian_case_info.CASE_REGISTER,                       O_ST_XTGLB_suqian_case_info.CASE_TITLE,                       O_ST_XTGLB_suqian_case_info.CASE_SERIAL,                       O_ST_XTGLB_suqian_case_info.ROWGUID                     from                       (                         select                           *                         from                           O_ST_XTGLB_suqian_case_info                       ) AS O_ST_XTGLB_suqian_case_info                   ) AS bhb18               ) AS bhb19             union all             select               bhb22.date_id,               bhb22.new_case_accord,               bhb22.case_accord_text,               bhb22.RELATION_DEPTS,               bhb22.RELATION_DEPTSCODE,               bhb22.ENTERPRISE_NAME,               bhb22.APPLICANT_TYPE,               bhb22.COMPLAINT_DETAIL,               bhb22.RQSTSOURCECHILD,               bhb22.ISKAOHE,               bhb22.flagguid,               bhb22.flag,               bhb22.FDBACK,               bhb22.SEND_TIME,               bhb22.FDBACKTIME,               bhb22.SIGN_TIME,               bhb22.HANDLETIME_LONG,               bhb22.FINISH_TYPE,               bhb22.FINISH_NOTE,               bhb22.FINISH_TIME,               bhb22.CONCACT_TIME,               bhb22.END_NAME,               bhb22.END_DEPT,               bhb22.VISIT_TYPE,               bhb22.VISIT_REMARK,               bhb22.SUBJECT_RESULT_SATIFY,               bhb22.OPERATEDATE1,               bhb22.REQUENCY,               bhb22.OPERATEDATE,               bhb22.THEME_SERIAL,               bhb22.CASE_HISTORYNUM,               bhb22.CERTIFICATE_TYPE,               bhb22.CASE_GOAL,               bhb22.EVENT_DATE,               bhb22.CASE_ADDRESS,               bhb22.CASE_EX_ACCORD,               bhb22.CASE_EMOTION,               bhb22.CASE_LNGLAT,               bhb22.CASE_AREA_CODE,               bhb22.RELATE_SERIAL,               bhb22.TBACKTIME_BF,               bhb22.TFDBACKTIME_BF,               bhb22.TSIGNTIME_BF,               bhb22.CASE_SERIAL_TURN,               bhb22.AREA_CODE,               bhb22.CASE_MARK,               bhb22.CASE_ISURGENT,               bhb22.CASE_ISVISIT,               bhb22.CASE_ISPUBLIC,               bhb22.CASE_PROCESS_TYPE,               bhb22.CASE_CONTENT,               bhb22.CASE_ACCORD,               bhb22.CASE_TYPE,               bhb22.APPLICANT_ID,               bhb22.APPLICANT_AGE,               bhb22.APPLICANT_SEX,               bhb22.APPLICANT_NAME,               bhb22.PHONE_NUMBER,               bhb22.CASE_SOURCE_DETAIL,               bhb22.CASE_SOURCE,               bhb22.CASE_DATE,               bhb22.CASE_REGISTERNO,               bhb22.CASE_REGISTER,               bhb22.CASE_TITLE,               bhb22.CASE_SERIAL,               bhb22.ROWGUID             from               (                 select                   bhb21.date_id as date_id,                   bhb21.new_case_accord as new_case_accord,                   bhb21.case_accord_text as case_accord_text,                   bhb21.RELATION_DEPTS as RELATION_DEPTS,                   bhb21.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                   bhb21.ENTERPRISE_NAME as ENTERPRISE_NAME,                   bhb21.APPLICANT_TYPE as APPLICANT_TYPE,                   bhb21.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                   bhb21.RQSTSOURCECHILD as RQSTSOURCECHILD,                   bhb21.ISKAOHE as ISKAOHE,                   bhb21.flagguid as flagguid,                   bhb21.flag as flag,                   bhb21.FDBACK as FDBACK,                   bhb21.SEND_TIME as SEND_TIME,                   bhb21.FDBACKTIME as FDBACKTIME,                   bhb21.SIGN_TIME as SIGN_TIME,                   bhb21.HANDLETIME_LONG as HANDLETIME_LONG,                   bhb21.FINISH_TYPE as FINISH_TYPE,                   bhb21.FINISH_NOTE as FINISH_NOTE,                   bhb21.FINISH_TIME as FINISH_TIME,                   bhb21.CONCACT_TIME as CONCACT_TIME,                   bhb21.END_NAME as END_NAME,                   bhb21.END_DEPT as END_DEPT,                   bhb21.VISIT_TYPE as VISIT_TYPE,                   bhb21.VISIT_REMARK as VISIT_REMARK,                   bhb21.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                   bhb21.OPERATEDATE1 as OPERATEDATE1,                   bhb21.REQUENCY as REQUENCY,                   bhb21.OPERATEDATE as OPERATEDATE,                   bhb21.THEME_SERIAL as THEME_SERIAL,                   bhb21.CASE_HISTORYNUM as CASE_HISTORYNUM,                   bhb21.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                   bhb21.CASE_GOAL as CASE_GOAL,                   bhb21.EVENT_DATE as EVENT_DATE,                   bhb21.CASE_ADDRESS as CASE_ADDRESS,                   bhb21.CASE_EX_ACCORD as CASE_EX_ACCORD,                   bhb21.CASE_EMOTION as CASE_EMOTION,                   bhb21.CASE_LNGLAT as CASE_LNGLAT,                   bhb21.CASE_AREA_CODE as CASE_AREA_CODE,                   bhb21.RELATE_SERIAL as RELATE_SERIAL,                   bhb21.TBACKTIME_BF as TBACKTIME_BF,                   bhb21.TFDBACKTIME_BF as TFDBACKTIME_BF,                   bhb21.TSIGNTIME_BF as TSIGNTIME_BF,                   bhb21.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                   bhb21.AREA_CODE as AREA_CODE,                   bhb21.CASE_MARK as CASE_MARK,                   bhb21.CASE_ISURGENT as CASE_ISURGENT,                   bhb21.CASE_ISVISIT as CASE_ISVISIT,                   bhb21.CASE_ISPUBLIC as CASE_ISPUBLIC,                   bhb21.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                   bhb21.CASE_CONTENT as CASE_CONTENT,                   bhb21.CASE_ACCORD as CASE_ACCORD,                   bhb21.CASE_TYPE as CASE_TYPE,                   bhb21.APPLICANT_ID as APPLICANT_ID,                   bhb21.APPLICANT_AGE as APPLICANT_AGE,                   bhb21.APPLICANT_SEX as APPLICANT_SEX,                   bhb21.APPLICANT_NAME as APPLICANT_NAME,                   bhb21.PHONE_NUMBER as PHONE_NUMBER,                   bhb21.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                   bhb21.CASE_SOURCE as CASE_SOURCE,                   bhb21.CASE_DATE as CASE_DATE,                   bhb21.CASE_REGISTERNO as CASE_REGISTERNO,                   bhb21.CASE_REGISTER as CASE_REGISTER,                   bhb21.CASE_TITLE as CASE_TITLE,                   bhb21.CASE_SERIAL as CASE_SERIAL,                   bhb21.ROWGUID as ROWGUID                 from                   (                     select                       bhb16.ROWGUID as ROWGUID,                       bhb16.CASE_SERIAL as CASE_SERIAL,                       bhb16.CASE_TITLE as CASE_TITLE,                       bhb16.CASE_REGISTER as CASE_REGISTER,                       bhb16.CASE_REGISTERNO as CASE_REGISTERNO,                       bhb16.CASE_DATE as CASE_DATE,                       bhb16.CASE_SOURCE as CASE_SOURCE,                       bhb16.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                       bhb16.PHONE_NUMBER as PHONE_NUMBER,                       bhb16.APPLICANT_NAME as APPLICANT_NAME,                       bhb16.APPLICANT_SEX as APPLICANT_SEX,                       bhb16.APPLICANT_AGE as APPLICANT_AGE,                       bhb16.APPLICANT_ID as APPLICANT_ID,                       bhb16.CASE_TYPE as CASE_TYPE,                       bhb16.CASE_ACCORD as CASE_ACCORD,                       bhb16.CASE_CONTENT as CASE_CONTENT,                       bhb16.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                       bhb16.CASE_ISPUBLIC as CASE_ISPUBLIC,                       bhb16.CASE_ISVISIT as CASE_ISVISIT,                       bhb16.CASE_ISURGENT as CASE_ISURGENT,                       bhb16.CASE_MARK as CASE_MARK,                       bhb16.AREA_CODE as AREA_CODE,                       bhb16.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                       bhb16.TSIGNTIME_BF as TSIGNTIME_BF,                       bhb16.TFDBACKTIME_BF as TFDBACKTIME_BF,                       bhb16.TBACKTIME_BF as TBACKTIME_BF,                       bhb16.RELATE_SERIAL as RELATE_SERIAL,                       bhb16.CASE_AREA_CODE as CASE_AREA_CODE,                       bhb16.CASE_LNGLAT as CASE_LNGLAT,                       bhb16.CASE_EMOTION as CASE_EMOTION,                       bhb16.CASE_EX_ACCORD as CASE_EX_ACCORD,                       bhb16.CASE_ADDRESS as CASE_ADDRESS,                       bhb16.EVENT_DATE as EVENT_DATE,                       bhb16.CASE_GOAL as CASE_GOAL,                       bhb16.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                       bhb16.CASE_HISTORYNUM as CASE_HISTORYNUM,                       bhb16.THEME_SERIAL as THEME_SERIAL,                       bhb16.OPERATEDATE as OPERATEDATE,                       bhb16.REQUENCY as REQUENCY,                       bhb16.OPERATEDATE1 as OPERATEDATE1,                       bhb16.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                       bhb16.VISIT_REMARK as VISIT_REMARK,                       bhb16.VISIT_TYPE as VISIT_TYPE,                       bhb16.END_DEPT as END_DEPT,                       bhb16.END_NAME as END_NAME,                       bhb16.CONCACT_TIME as CONCACT_TIME,                       bhb16.FINISH_TIME as FINISH_TIME,                       bhb16.FINISH_NOTE as FINISH_NOTE,                       bhb16.FINISH_TYPE as FINISH_TYPE,                       bhb16.HANDLETIME_LONG as HANDLETIME_LONG,                       bhb16.SIGN_TIME as SIGN_TIME,                       bhb16.FDBACKTIME as FDBACKTIME,                       bhb16.SEND_TIME as SEND_TIME,                       bhb16.FDBACK as FDBACK,                       bhb16.flag as flag,                       bhb16.flagguid as flagguid,                       bhb16.ISKAOHE as ISKAOHE,                       bhb16.RQSTSOURCECHILD as RQSTSOURCECHILD,                       bhb16.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                       bhb16.APPLICANT_TYPE as APPLICANT_TYPE,                       bhb16.ENTERPRISE_NAME as ENTERPRISE_NAME,                       bhb16.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                       bhb16.RELATION_DEPTS as RELATION_DEPTS,                       bhb16.case_accord_text as case_accord_text,                       bhb16.new_case_accord as new_case_accord,                       bhb16.date_id as date_id                     from                       (                         select                           O_ST_XTGLB_yangzhou_case_info.date_id as date_id,                           O_ST_XTGLB_yangzhou_case_info.new_case_accord as new_case_accord,                           O_ST_XTGLB_yangzhou_case_info.case_accord_text as case_accord_text,                           O_ST_XTGLB_yangzhou_case_info.RELATION_POLICE_OFFICER as RELATION_POLICE_OFFICER,                           O_ST_XTGLB_yangzhou_case_info.RELATION_DEPTS as RELATION_DEPTS,                           O_ST_XTGLB_yangzhou_case_info.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                           O_ST_XTGLB_yangzhou_case_info.ENTERPRISE_NAME as ENTERPRISE_NAME,                           O_ST_XTGLB_yangzhou_case_info.APPLICANT_TYPE as APPLICANT_TYPE,                           O_ST_XTGLB_yangzhou_case_info.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                           O_ST_XTGLB_yangzhou_case_info.RQSTSOURCECHILD as RQSTSOURCECHILD,                           O_ST_XTGLB_yangzhou_case_info.ISKAOHE as ISKAOHE,                           O_ST_XTGLB_yangzhou_case_info.flagguid as flagguid,                           O_ST_XTGLB_yangzhou_case_info.flag as flag,                           O_ST_XTGLB_yangzhou_case_info.FDBACK as FDBACK,                           O_ST_XTGLB_yangzhou_case_info.SEND_TIME as SEND_TIME,                           O_ST_XTGLB_yangzhou_case_info.FDBACKTIME as FDBACKTIME,                           O_ST_XTGLB_yangzhou_case_info.SIGN_TIME as SIGN_TIME,                           O_ST_XTGLB_yangzhou_case_info.HANDLETIME_LONG as HANDLETIME_LONG,                           O_ST_XTGLB_yangzhou_case_info.FINISH_TYPE as FINISH_TYPE,                           O_ST_XTGLB_yangzhou_case_info.FINISH_NOTE as FINISH_NOTE,                           O_ST_XTGLB_yangzhou_case_info.FINISH_TIME as FINISH_TIME,                           O_ST_XTGLB_yangzhou_case_info.CONCACT_TIME as CONCACT_TIME,                           O_ST_XTGLB_yangzhou_case_info.END_NAME as END_NAME,                           O_ST_XTGLB_yangzhou_case_info.END_DEPT as END_DEPT,                           O_ST_XTGLB_yangzhou_case_info.VISIT_TYPE as VISIT_TYPE,                           O_ST_XTGLB_yangzhou_case_info.VISIT_REMARK as VISIT_REMARK,                           O_ST_XTGLB_yangzhou_case_info.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                           O_ST_XTGLB_yangzhou_case_info.OPERATEDATE1 as OPERATEDATE1,                           O_ST_XTGLB_yangzhou_case_info.REQUENCY as REQUENCY,                           O_ST_XTGLB_yangzhou_case_info.OPERATEDATE as OPERATEDATE,                           O_ST_XTGLB_yangzhou_case_info.THEME_SERIAL as THEME_SERIAL,                           O_ST_XTGLB_yangzhou_case_info.CASE_HISTORYNUM as CASE_HISTORYNUM,                           O_ST_XTGLB_yangzhou_case_info.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                           O_ST_XTGLB_yangzhou_case_info.CASE_GOAL as CASE_GOAL,                           O_ST_XTGLB_yangzhou_case_info.EVENT_DATE as EVENT_DATE,                           O_ST_XTGLB_yangzhou_case_info.CASE_ADDRESS as CASE_ADDRESS,                           O_ST_XTGLB_yangzhou_case_info.CASE_EX_ACCORD as CASE_EX_ACCORD,                           O_ST_XTGLB_yangzhou_case_info.CASE_EMOTION as CASE_EMOTION,                           O_ST_XTGLB_yangzhou_case_info.CASE_LNGLAT as CASE_LNGLAT,                           O_ST_XTGLB_yangzhou_case_info.CASE_AREA_CODE as CASE_AREA_CODE,                           O_ST_XTGLB_yangzhou_case_info.RELATE_SERIAL as RELATE_SERIAL,                           O_ST_XTGLB_yangzhou_case_info.TBACKTIME_BF as TBACKTIME_BF,                           O_ST_XTGLB_yangzhou_case_info.TFDBACKTIME_BF as TFDBACKTIME_BF,                           O_ST_XTGLB_yangzhou_case_info.TSIGNTIME_BF as TSIGNTIME_BF,                           O_ST_XTGLB_yangzhou_case_info.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                           O_ST_XTGLB_yangzhou_case_info.AREA_CODE as AREA_CODE,                           O_ST_XTGLB_yangzhou_case_info.CASE_MARK as CASE_MARK,                           O_ST_XTGLB_yangzhou_case_info.CASE_ISURGENT as CASE_ISURGENT,                           O_ST_XTGLB_yangzhou_case_info.CASE_ISVISIT as CASE_ISVISIT,                           O_ST_XTGLB_yangzhou_case_info.CASE_ISPUBLIC as CASE_ISPUBLIC,                           O_ST_XTGLB_yangzhou_case_info.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                           O_ST_XTGLB_yangzhou_case_info.CASE_CONTENT as CASE_CONTENT,                           O_ST_XTGLB_yangzhou_case_info.CASE_ACCORD as CASE_ACCORD,                           O_ST_XTGLB_yangzhou_case_info.CASE_TYPE as CASE_TYPE,                           O_ST_XTGLB_yangzhou_case_info.APPLICANT_ID as APPLICANT_ID,                           O_ST_XTGLB_yangzhou_case_info.APPLICANT_AGE as APPLICANT_AGE,                           O_ST_XTGLB_yangzhou_case_info.APPLICANT_SEX as APPLICANT_SEX,                           O_ST_XTGLB_yangzhou_case_info.APPLICANT_NAME as APPLICANT_NAME,                           O_ST_XTGLB_yangzhou_case_info.PHONE_NUMBER as PHONE_NUMBER,                           O_ST_XTGLB_yangzhou_case_info.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                           O_ST_XTGLB_yangzhou_case_info.CASE_SOURCE as CASE_SOURCE,                           O_ST_XTGLB_yangzhou_case_info.CASE_DATE as CASE_DATE,                           O_ST_XTGLB_yangzhou_case_info.CASE_REGISTERNO as CASE_REGISTERNO,                           O_ST_XTGLB_yangzhou_case_info.CASE_REGISTER as CASE_REGISTER,                           O_ST_XTGLB_yangzhou_case_info.CASE_TITLE as CASE_TITLE,                           O_ST_XTGLB_yangzhou_case_info.CASE_SERIAL as CASE_SERIAL,                           O_ST_XTGLB_yangzhou_case_info.ROWGUID as ROWGUID                         from                           (                             select                               *                             from                               O_ST_XTGLB_yangzhou_case_info                           ) AS O_ST_XTGLB_yangzhou_case_info                         union all                         select                           O_ST_XTGLB_nanjing_case_info.date_id,                           O_ST_XTGLB_nanjing_case_info.new_case_accord,                           O_ST_XTGLB_nanjing_case_info.case_accord_text,                           O_ST_XTGLB_nanjing_case_info.RELATION_POLICE_OFFICER,                           O_ST_XTGLB_nanjing_case_info.RELATION_DEPTS,                           O_ST_XTGLB_nanjing_case_info.RELATION_DEPTSCODE,                           O_ST_XTGLB_nanjing_case_info.ENTERPRISE_NAME,                           O_ST_XTGLB_nanjing_case_info.APPLICANT_TYPE,                           O_ST_XTGLB_nanjing_case_info.COMPLAINT_DETAIL,                           O_ST_XTGLB_nanjing_case_info.RQSTSOURCECHILD,                           O_ST_XTGLB_nanjing_case_info.ISKAOHE,                           O_ST_XTGLB_nanjing_case_info.flagguid,                           O_ST_XTGLB_nanjing_case_info.flag,                           O_ST_XTGLB_nanjing_case_info.FDBACK,                           O_ST_XTGLB_nanjing_case_info.SEND_TIME,                           O_ST_XTGLB_nanjing_case_info.FDBACKTIME,                           O_ST_XTGLB_nanjing_case_info.SIGN_TIME,                           O_ST_XTGLB_nanjing_case_info.HANDLETIME_LONG,                           O_ST_XTGLB_nanjing_case_info.FINISH_TYPE,                           O_ST_XTGLB_nanjing_case_info.FINISH_NOTE,                           O_ST_XTGLB_nanjing_case_info.FINISH_TIME,                           O_ST_XTGLB_nanjing_case_info.CONCACT_TIME,                           O_ST_XTGLB_nanjing_case_info.END_NAME,                           O_ST_XTGLB_nanjing_case_info.END_DEPT,                           O_ST_XTGLB_nanjing_case_info.VISIT_TYPE,                           O_ST_XTGLB_nanjing_case_info.VISIT_REMARK,                           O_ST_XTGLB_nanjing_case_info.SUBJECT_RESULT_SATIFY,                           O_ST_XTGLB_nanjing_case_info.OPERATEDATE1,                           O_ST_XTGLB_nanjing_case_info.REQUENCY,                           O_ST_XTGLB_nanjing_case_info.OPERATEDATE,                           O_ST_XTGLB_nanjing_case_info.THEME_SERIAL,                           O_ST_XTGLB_nanjing_case_info.CASE_HISTORYNUM,                           O_ST_XTGLB_nanjing_case_info.CERTIFICATE_TYPE,                           O_ST_XTGLB_nanjing_case_info.CASE_GOAL,                           O_ST_XTGLB_nanjing_case_info.EVENT_DATE,                           O_ST_XTGLB_nanjing_case_info.CASE_ADDRESS,                           O_ST_XTGLB_nanjing_case_info.CASE_EX_ACCORD,                           O_ST_XTGLB_nanjing_case_info.CASE_EMOTION,                           O_ST_XTGLB_nanjing_case_info.CASE_LNGLAT,                           O_ST_XTGLB_nanjing_case_info.CASE_AREA_CODE,                           O_ST_XTGLB_nanjing_case_info.RELATE_SERIAL,                           O_ST_XTGLB_nanjing_case_info.TBACKTIME_BF,                           O_ST_XTGLB_nanjing_case_info.TFDBACKTIME_BF,                           O_ST_XTGLB_nanjing_case_info.TSIGNTIME_BF,                           O_ST_XTGLB_nanjing_case_info.CASE_SERIAL_TURN,                           O_ST_XTGLB_nanjing_case_info.AREA_CODE,                           O_ST_XTGLB_nanjing_case_info.CASE_MARK,                           O_ST_XTGLB_nanjing_case_info.CASE_ISURGENT,                           O_ST_XTGLB_nanjing_case_info.CASE_ISVISIT,                           O_ST_XTGLB_nanjing_case_info.CASE_ISPUBLIC,                           O_ST_XTGLB_nanjing_case_info.CASE_PROCESS_TYPE,                           O_ST_XTGLB_nanjing_case_info.CASE_CONTENT,                           O_ST_XTGLB_nanjing_case_info.CASE_ACCORD,                           O_ST_XTGLB_nanjing_case_info.CASE_TYPE,                           O_ST_XTGLB_nanjing_case_info.APPLICANT_ID,                           O_ST_XTGLB_nanjing_case_info.APPLICANT_AGE,                           O_ST_XTGLB_nanjing_case_info.APPLICANT_SEX,                           O_ST_XTGLB_nanjing_case_info.APPLICANT_NAME,                           O_ST_XTGLB_nanjing_case_info.PHONE_NUMBER,                           O_ST_XTGLB_nanjing_case_info.CASE_SOURCE_DETAIL,                           O_ST_XTGLB_nanjing_case_info.CASE_SOURCE,                           O_ST_XTGLB_nanjing_case_info.CASE_DATE,                           O_ST_XTGLB_nanjing_case_info.CASE_REGISTERNO,                           O_ST_XTGLB_nanjing_case_info.CASE_REGISTER,                           O_ST_XTGLB_nanjing_case_info.CASE_TITLE,                           O_ST_XTGLB_nanjing_case_info.CASE_SERIAL,                           O_ST_XTGLB_nanjing_case_info.ROWGUID                         from                           (                             select                               *                             from                               O_ST_XTGLB_nanjing_case_info                           ) AS O_ST_XTGLB_nanjing_case_info                       ) AS bhb16                     union all                     select                       bhb15.ROWGUID,                       bhb15.CASE_SERIAL,                       bhb15.CASE_TITLE,                       bhb15.CASE_REGISTER,                       bhb15.CASE_REGISTERNO,                       bhb15.CASE_DATE,                       bhb15.CASE_SOURCE,                       bhb15.CASE_SOURCE_DETAIL,                       bhb15.PHONE_NUMBER,                       bhb15.APPLICANT_NAME,                       bhb15.APPLICANT_SEX,                       bhb15.APPLICANT_AGE,                       bhb15.APPLICANT_ID,                       bhb15.CASE_TYPE,                       bhb15.CASE_ACCORD,                       bhb15.CASE_CONTENT,                       bhb15.CASE_PROCESS_TYPE,                       bhb15.CASE_ISPUBLIC,                       bhb15.CASE_ISVISIT,                       bhb15.CASE_ISURGENT,                       bhb15.CASE_MARK,                       bhb15.AREA_CODE,                       bhb15.CASE_SERIAL_TURN,                       bhb15.TSIGNTIME_BF,                       bhb15.TFDBACKTIME_BF,                       bhb15.TBACKTIME_BF,                       bhb15.RELATE_SERIAL,                       bhb15.CASE_AREA_CODE,                       bhb15.CASE_LNGLAT,                       bhb15.CASE_EMOTION,                       bhb15.CASE_EX_ACCORD,                       bhb15.CASE_ADDRESS,                       bhb15.EVENT_DATE,                       bhb15.CASE_GOAL,                       bhb15.CERTIFICATE_TYPE,                       bhb15.CASE_HISTORYNUM,                       bhb15.THEME_SERIAL,                       bhb15.OPERATEDATE,                       bhb15.REQUENCY,                       bhb15.OPERATEDATE1,                       bhb15.SUBJECT_RESULT_SATIFY,                       bhb15.VISIT_REMARK,                       bhb15.VISIT_TYPE,                       bhb15.END_DEPT,                       bhb15.END_NAME,                       bhb15.CONCACT_TIME,                       bhb15.FINISH_TIME,                       bhb15.FINISH_NOTE,                       bhb15.FINISH_TYPE,                       bhb15.HANDLETIME_LONG,                       bhb15.SIGN_TIME,                       bhb15.FDBACKTIME,                       bhb15.SEND_TIME,                       bhb15.FDBACK,                       bhb15.flag,                       bhb15.flagguid,                       bhb15.ISKAOHE,                       bhb15.RQSTSOURCECHILD,                       bhb15.COMPLAINT_DETAIL,                       bhb15.APPLICANT_TYPE,                       bhb15.ENTERPRISE_NAME,                       bhb15.RELATION_DEPTSCODE,                       bhb15.RELATION_DEPTS,                       bhb15.case_accord_text,                       bhb15.new_case_accord,                       bhb15.date_id                     from                       (                         select                           O_ST_XTGLB_wuxi_case_info.date_id as date_id,                           O_ST_XTGLB_wuxi_case_info.new_case_accord as new_case_accord,                           O_ST_XTGLB_wuxi_case_info.case_accord_text as case_accord_text,                           O_ST_XTGLB_wuxi_case_info.RELATION_DEPTS as RELATION_DEPTS,                           O_ST_XTGLB_wuxi_case_info.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                           O_ST_XTGLB_wuxi_case_info.ENTERPRISE_NAME as ENTERPRISE_NAME,                           O_ST_XTGLB_wuxi_case_info.APPLICANT_TYPE as APPLICANT_TYPE,                           O_ST_XTGLB_wuxi_case_info.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                           O_ST_XTGLB_wuxi_case_info.RQSTSOURCECHILD as RQSTSOURCECHILD,                           O_ST_XTGLB_wuxi_case_info.ISKAOHE as ISKAOHE,                           O_ST_XTGLB_wuxi_case_info.flagguid as flagguid,                           O_ST_XTGLB_wuxi_case_info.flag as flag,                           O_ST_XTGLB_wuxi_case_info.FDBACK as FDBACK,                           O_ST_XTGLB_wuxi_case_info.SEND_TIME as SEND_TIME,                           O_ST_XTGLB_wuxi_case_info.FDBACKTIME as FDBACKTIME,                           O_ST_XTGLB_wuxi_case_info.SIGN_TIME as SIGN_TIME,                           O_ST_XTGLB_wuxi_case_info.HANDLETIME_LONG as HANDLETIME_LONG,                           O_ST_XTGLB_wuxi_case_info.FINISH_TYPE as FINISH_TYPE,                           O_ST_XTGLB_wuxi_case_info.FINISH_NOTE as FINISH_NOTE,                           O_ST_XTGLB_wuxi_case_info.FINISH_TIME as FINISH_TIME,                           O_ST_XTGLB_wuxi_case_info.CONCACT_TIME as CONCACT_TIME,                           O_ST_XTGLB_wuxi_case_info.END_NAME as END_NAME,                           O_ST_XTGLB_wuxi_case_info.END_DEPT as END_DEPT,                           O_ST_XTGLB_wuxi_case_info.VISIT_TYPE as VISIT_TYPE,                           O_ST_XTGLB_wuxi_case_info.VISIT_REMARK as VISIT_REMARK,                           O_ST_XTGLB_wuxi_case_info.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                           O_ST_XTGLB_wuxi_case_info.OPERATEDATE1 as OPERATEDATE1,                           O_ST_XTGLB_wuxi_case_info.REQUENCY as REQUENCY,                           O_ST_XTGLB_wuxi_case_info.OPERATEDATE as OPERATEDATE,                           O_ST_XTGLB_wuxi_case_info.THEME_SERIAL as THEME_SERIAL,                           O_ST_XTGLB_wuxi_case_info.CASE_HISTORYNUM as CASE_HISTORYNUM,                           O_ST_XTGLB_wuxi_case_info.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                           O_ST_XTGLB_wuxi_case_info.CASE_GOAL as CASE_GOAL,                           O_ST_XTGLB_wuxi_case_info.EVENT_DATE as EVENT_DATE,                           O_ST_XTGLB_wuxi_case_info.CASE_ADDRESS as CASE_ADDRESS,                           O_ST_XTGLB_wuxi_case_info.CASE_EX_ACCORD as CASE_EX_ACCORD,                           O_ST_XTGLB_wuxi_case_info.CASE_EMOTION as CASE_EMOTION,                           O_ST_XTGLB_wuxi_case_info.CASE_LNGLAT as CASE_LNGLAT,                           O_ST_XTGLB_wuxi_case_info.CASE_AREA_CODE as CASE_AREA_CODE,                           O_ST_XTGLB_wuxi_case_info.RELATE_SERIAL as RELATE_SERIAL,                           O_ST_XTGLB_wuxi_case_info.TBACKTIME_BF as TBACKTIME_BF,                           O_ST_XTGLB_wuxi_case_info.TFDBACKTIME_BF as TFDBACKTIME_BF,                           O_ST_XTGLB_wuxi_case_info.TSIGNTIME_BF as TSIGNTIME_BF,                           O_ST_XTGLB_wuxi_case_info.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                           O_ST_XTGLB_wuxi_case_info.AREA_CODE as AREA_CODE,                           O_ST_XTGLB_wuxi_case_info.CASE_MARK as CASE_MARK,                           O_ST_XTGLB_wuxi_case_info.CASE_ISURGENT as CASE_ISURGENT,                           O_ST_XTGLB_wuxi_case_info.CASE_ISVISIT as CASE_ISVISIT,                           O_ST_XTGLB_wuxi_case_info.CASE_ISPUBLIC as CASE_ISPUBLIC,                           O_ST_XTGLB_wuxi_case_info.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                           O_ST_XTGLB_wuxi_case_info.CASE_CONTENT as CASE_CONTENT,                           O_ST_XTGLB_wuxi_case_info.CASE_ACCORD as CASE_ACCORD,                           O_ST_XTGLB_wuxi_case_info.CASE_TYPE as CASE_TYPE,                           O_ST_XTGLB_wuxi_case_info.APPLICANT_ID as APPLICANT_ID,                           O_ST_XTGLB_wuxi_case_info.APPLICANT_AGE as APPLICANT_AGE,                           O_ST_XTGLB_wuxi_case_info.APPLICANT_SEX as APPLICANT_SEX,                           O_ST_XTGLB_wuxi_case_info.APPLICANT_NAME as APPLICANT_NAME,                           O_ST_XTGLB_wuxi_case_info.PHONE_NUMBER as PHONE_NUMBER,                           O_ST_XTGLB_wuxi_case_info.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                           O_ST_XTGLB_wuxi_case_info.CASE_SOURCE as CASE_SOURCE,                           O_ST_XTGLB_wuxi_case_info.CASE_DATE as CASE_DATE,                           O_ST_XTGLB_wuxi_case_info.CASE_REGISTERNO as CASE_REGISTERNO,                           O_ST_XTGLB_wuxi_case_info.CASE_REGISTER as CASE_REGISTER,                           O_ST_XTGLB_wuxi_case_info.CASE_TITLE as CASE_TITLE,                           O_ST_XTGLB_wuxi_case_info.CASE_SERIAL as CASE_SERIAL,                           O_ST_XTGLB_wuxi_case_info.ROWGUID as ROWGUID                         from                           (                             select                               *                             from                               O_ST_XTGLB_wuxi_case_info                           ) AS O_ST_XTGLB_wuxi_case_info                         union all                         select                           O_ST_XTGLB_huaian_case_info.date_id,                           O_ST_XTGLB_huaian_case_info.new_case_accord,                           O_ST_XTGLB_huaian_case_info.case_accord_text,                           O_ST_XTGLB_huaian_case_info.RELATION_DEPTS,                           O_ST_XTGLB_huaian_case_info.RELATION_DEPTSCODE,                           O_ST_XTGLB_huaian_case_info.ENTERPRISE_NAME,                           O_ST_XTGLB_huaian_case_info.APPLICANT_TYPE,                           O_ST_XTGLB_huaian_case_info.COMPLAINT_DETAIL,                           O_ST_XTGLB_huaian_case_info.RQSTSOURCECHILD,                           O_ST_XTGLB_huaian_case_info.ISKAOHE,                           O_ST_XTGLB_huaian_case_info.flagguid,                           O_ST_XTGLB_huaian_case_info.flag,                           O_ST_XTGLB_huaian_case_info.FDBACK,                           O_ST_XTGLB_huaian_case_info.SEND_TIME,                           O_ST_XTGLB_huaian_case_info.FDBACKTIME,                           O_ST_XTGLB_huaian_case_info.SIGN_TIME,                           O_ST_XTGLB_huaian_case_info.HANDLETIME_LONG,                           O_ST_XTGLB_huaian_case_info.FINISH_TYPE,                           O_ST_XTGLB_huaian_case_info.FINISH_NOTE,                           O_ST_XTGLB_huaian_case_info.FINISH_TIME,                           O_ST_XTGLB_huaian_case_info.CONCACT_TIME,                           O_ST_XTGLB_huaian_case_info.END_NAME,                           O_ST_XTGLB_huaian_case_info.END_DEPT,                           O_ST_XTGLB_huaian_case_info.VISIT_TYPE,                           O_ST_XTGLB_huaian_case_info.VISIT_REMARK,                           O_ST_XTGLB_huaian_case_info.SUBJECT_RESULT_SATIFY,                           O_ST_XTGLB_huaian_case_info.OPERATEDATE1,                           O_ST_XTGLB_huaian_case_info.REQUENCY,                           O_ST_XTGLB_huaian_case_info.OPERATEDATE,                           O_ST_XTGLB_huaian_case_info.THEME_SERIAL,                           O_ST_XTGLB_huaian_case_info.CASE_HISTORYNUM,                           O_ST_XTGLB_huaian_case_info.CERTIFICATE_TYPE,                           O_ST_XTGLB_huaian_case_info.CASE_GOAL,                           O_ST_XTGLB_huaian_case_info.EVENT_DATE,                           O_ST_XTGLB_huaian_case_info.CASE_ADDRESS,                           O_ST_XTGLB_huaian_case_info.CASE_EX_ACCORD,                           O_ST_XTGLB_huaian_case_info.CASE_EMOTION,                           O_ST_XTGLB_huaian_case_info.CASE_LNGLAT,                           O_ST_XTGLB_huaian_case_info.CASE_AREA_CODE,                           O_ST_XTGLB_huaian_case_info.RELATE_SERIAL,                           O_ST_XTGLB_huaian_case_info.TBACKTIME_BF,                           O_ST_XTGLB_huaian_case_info.TFDBACKTIME_BF,                           O_ST_XTGLB_huaian_case_info.TSIGNTIME_BF,                           O_ST_XTGLB_huaian_case_info.CASE_SERIAL_TURN,                           O_ST_XTGLB_huaian_case_info.AREA_CODE,                           O_ST_XTGLB_huaian_case_info.CASE_MARK,                           O_ST_XTGLB_huaian_case_info.CASE_ISURGENT,                           O_ST_XTGLB_huaian_case_info.CASE_ISVISIT,                           O_ST_XTGLB_huaian_case_info.CASE_ISPUBLIC,                           O_ST_XTGLB_huaian_case_info.CASE_PROCESS_TYPE,                           O_ST_XTGLB_huaian_case_info.CASE_CONTENT,                           O_ST_XTGLB_huaian_case_info.CASE_ACCORD,                           O_ST_XTGLB_huaian_case_info.CASE_TYPE,                           O_ST_XTGLB_huaian_case_info.APPLICANT_ID,                           O_ST_XTGLB_huaian_case_info.APPLICANT_AGE,                           O_ST_XTGLB_huaian_case_info.APPLICANT_SEX,                           O_ST_XTGLB_huaian_case_info.APPLICANT_NAME,                           O_ST_XTGLB_huaian_case_info.PHONE_NUMBER,                           O_ST_XTGLB_huaian_case_info.CASE_SOURCE_DETAIL,                           O_ST_XTGLB_huaian_case_info.CASE_SOURCE,                           O_ST_XTGLB_huaian_case_info.CASE_DATE,                           O_ST_XTGLB_huaian_case_info.CASE_REGISTERNO,                           O_ST_XTGLB_huaian_case_info.CASE_REGISTER,                           O_ST_XTGLB_huaian_case_info.CASE_TITLE,                           O_ST_XTGLB_huaian_case_info.CASE_SERIAL,                           O_ST_XTGLB_huaian_case_info.ROWGUID                         from                           (                             select                               *                             from                               O_ST_XTGLB_huaian_case_info                           ) AS O_ST_XTGLB_huaian_case_info                       ) AS bhb15                   ) AS bhb21                 union all                 select                   bhb20.date_id,                   bhb20.new_case_accord,                   bhb20.case_accord_text,                   bhb20.RELATION_DEPTS,                   bhb20.RELATION_DEPTSCODE,                   bhb20.ENTERPRISE_NAME,                   bhb20.APPLICANT_TYPE,                   bhb20.COMPLAINT_DETAIL,                   bhb20.RQSTSOURCECHILD,                   bhb20.ISKAOHE,                   bhb20.flagguid,                   bhb20.flag,                   bhb20.FDBACK,                   bhb20.SEND_TIME,                   bhb20.FDBACKTIME,                   bhb20.SIGN_TIME,                   bhb20.HANDLETIME_LONG,                   bhb20.FINISH_TYPE,                   bhb20.FINISH_NOTE,                   bhb20.FINISH_TIME,                   bhb20.CONCACT_TIME,                   bhb20.END_NAME,                   bhb20.END_DEPT,                   bhb20.VISIT_TYPE,                   bhb20.VISIT_REMARK,                   bhb20.SUBJECT_RESULT_SATIFY,                   bhb20.OPERATEDATE1,                   bhb20.REQUENCY,                   bhb20.OPERATEDATE,                   bhb20.THEME_SERIAL,                   bhb20.CASE_HISTORYNUM,                   bhb20.CERTIFICATE_TYPE,                   bhb20.CASE_GOAL,                   bhb20.EVENT_DATE,                   bhb20.CASE_ADDRESS,                   bhb20.CASE_EX_ACCORD,                   bhb20.CASE_EMOTION,                   bhb20.CASE_LNGLAT,                   bhb20.CASE_AREA_CODE,                   bhb20.RELATE_SERIAL,                   bhb20.TBACKTIME_BF,                   bhb20.TFDBACKTIME_BF,                   bhb20.TSIGNTIME_BF,                   bhb20.CASE_SERIAL_TURN,                   bhb20.AREA_CODE,                   bhb20.CASE_MARK,                   bhb20.CASE_ISURGENT,                   bhb20.CASE_ISVISIT,                   bhb20.CASE_ISPUBLIC,                   bhb20.CASE_PROCESS_TYPE,                   bhb20.CASE_CONTENT,                   bhb20.CASE_ACCORD,                   bhb20.CASE_TYPE,                   bhb20.APPLICANT_ID,                   bhb20.APPLICANT_AGE,                   bhb20.APPLICANT_SEX,                   bhb20.APPLICANT_NAME,                   bhb20.PHONE_NUMBER,                   bhb20.CASE_SOURCE_DETAIL,                   bhb20.CASE_SOURCE,                   bhb20.CASE_DATE,                   bhb20.CASE_REGISTERNO,                   bhb20.CASE_REGISTER,                   bhb20.CASE_TITLE,                   bhb20.CASE_SERIAL,                   bhb20.ROWGUID                 from                   (                     select                       bhb13.ROWGUID as ROWGUID,                       bhb13.CASE_SERIAL as CASE_SERIAL,                       bhb13.CASE_TITLE as CASE_TITLE,                       bhb13.CASE_REGISTER as CASE_REGISTER,                       bhb13.CASE_REGISTERNO as CASE_REGISTERNO,                       bhb13.CASE_DATE as CASE_DATE,                       bhb13.CASE_SOURCE as CASE_SOURCE,                       bhb13.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                       bhb13.PHONE_NUMBER as PHONE_NUMBER,                       bhb13.APPLICANT_NAME as APPLICANT_NAME,                       bhb13.APPLICANT_SEX as APPLICANT_SEX,                       bhb13.APPLICANT_AGE as APPLICANT_AGE,                       bhb13.APPLICANT_ID as APPLICANT_ID,                       bhb13.CASE_TYPE as CASE_TYPE,                       bhb13.CASE_ACCORD as CASE_ACCORD,                       bhb13.CASE_CONTENT as CASE_CONTENT,                       bhb13.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                       bhb13.CASE_ISPUBLIC as CASE_ISPUBLIC,                       bhb13.CASE_ISVISIT as CASE_ISVISIT,                       bhb13.CASE_ISURGENT as CASE_ISURGENT,                       bhb13.CASE_MARK as CASE_MARK,                       bhb13.AREA_CODE as AREA_CODE,                       bhb13.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                       bhb13.TSIGNTIME_BF as TSIGNTIME_BF,                       bhb13.TFDBACKTIME_BF as TFDBACKTIME_BF,                       bhb13.TBACKTIME_BF as TBACKTIME_BF,                       bhb13.RELATE_SERIAL as RELATE_SERIAL,                       bhb13.CASE_AREA_CODE as CASE_AREA_CODE,                       bhb13.CASE_LNGLAT as CASE_LNGLAT,                       bhb13.CASE_EMOTION as CASE_EMOTION,                       bhb13.CASE_EX_ACCORD as CASE_EX_ACCORD,                       bhb13.CASE_ADDRESS as CASE_ADDRESS,                       bhb13.EVENT_DATE as EVENT_DATE,                       bhb13.CASE_GOAL as CASE_GOAL,                       bhb13.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                       bhb13.CASE_HISTORYNUM as CASE_HISTORYNUM,                       bhb13.THEME_SERIAL as THEME_SERIAL,                       bhb13.OPERATEDATE as OPERATEDATE,                       bhb13.REQUENCY as REQUENCY,                       bhb13.OPERATEDATE1 as OPERATEDATE1,                       bhb13.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                       bhb13.VISIT_REMARK as VISIT_REMARK,                       bhb13.VISIT_TYPE as VISIT_TYPE,                       bhb13.END_DEPT as END_DEPT,                       bhb13.END_NAME as END_NAME,                       bhb13.CONCACT_TIME as CONCACT_TIME,                       bhb13.FINISH_TIME as FINISH_TIME,                       bhb13.FINISH_NOTE as FINISH_NOTE,                       bhb13.FINISH_TYPE as FINISH_TYPE,                       bhb13.HANDLETIME_LONG as HANDLETIME_LONG,                       bhb13.SIGN_TIME as SIGN_TIME,                       bhb13.FDBACKTIME as FDBACKTIME,                       bhb13.SEND_TIME as SEND_TIME,                       bhb13.FDBACK as FDBACK,                       bhb13.flag as flag,                       bhb13.flagguid as flagguid,                       bhb13.ISKAOHE as ISKAOHE,                       bhb13.RQSTSOURCECHILD as RQSTSOURCECHILD,                       bhb13.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                       bhb13.APPLICANT_TYPE as APPLICANT_TYPE,                       bhb13.ENTERPRISE_NAME as ENTERPRISE_NAME,                       bhb13.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                       bhb13.RELATION_DEPTS as RELATION_DEPTS,                       bhb13.RELATION_POLICE_OFFICER as RELATION_POLICE_OFFICER,                       bhb13.case_accord_text as case_accord_text,                       bhb13.new_case_accord as new_case_accord,                       bhb13.date_id as date_id                     from                       (                         select                           O_ST_XTGLB_zhenjiang_case_info.date_id as date_id,                           O_ST_XTGLB_zhenjiang_case_info.new_case_accord as new_case_accord,                           O_ST_XTGLB_zhenjiang_case_info.case_accord_text as case_accord_text,                           O_ST_XTGLB_zhenjiang_case_info.RELATION_POLICE_OFFICER as RELATION_POLICE_OFFICER,                           O_ST_XTGLB_zhenjiang_case_info.RELATION_DEPTS as RELATION_DEPTS,                           O_ST_XTGLB_zhenjiang_case_info.RELATION_DEPTSCODE as RELATION_DEPTSCODE,                           O_ST_XTGLB_zhenjiang_case_info.ENTERPRISE_NAME as ENTERPRISE_NAME,                           O_ST_XTGLB_zhenjiang_case_info.APPLICANT_TYPE as APPLICANT_TYPE,                           O_ST_XTGLB_zhenjiang_case_info.COMPLAINT_DETAIL as COMPLAINT_DETAIL,                           O_ST_XTGLB_zhenjiang_case_info.RQSTSOURCECHILD as RQSTSOURCECHILD,                           O_ST_XTGLB_zhenjiang_case_info.ISKAOHE as ISKAOHE,                           O_ST_XTGLB_zhenjiang_case_info.flagguid as flagguid,                           O_ST_XTGLB_zhenjiang_case_info.flag as flag,                           O_ST_XTGLB_zhenjiang_case_info.FDBACK as FDBACK,                           O_ST_XTGLB_zhenjiang_case_info.SEND_TIME as SEND_TIME,                           O_ST_XTGLB_zhenjiang_case_info.FDBACKTIME as FDBACKTIME,                           O_ST_XTGLB_zhenjiang_case_info.SIGN_TIME as SIGN_TIME,                           O_ST_XTGLB_zhenjiang_case_info.HANDLETIME_LONG as HANDLETIME_LONG,                           O_ST_XTGLB_zhenjiang_case_info.FINISH_TYPE as FINISH_TYPE,                           O_ST_XTGLB_zhenjiang_case_info.FINISH_NOTE as FINISH_NOTE,                           O_ST_XTGLB_zhenjiang_case_info.FINISH_TIME as FINISH_TIME,                           O_ST_XTGLB_zhenjiang_case_info.CONCACT_TIME as CONCACT_TIME,                           O_ST_XTGLB_zhenjiang_case_info.END_NAME as END_NAME,                           O_ST_XTGLB_zhenjiang_case_info.END_DEPT as END_DEPT,                           O_ST_XTGLB_zhenjiang_case_info.VISIT_TYPE as VISIT_TYPE,                           O_ST_XTGLB_zhenjiang_case_info.VISIT_REMARK as VISIT_REMARK,                           O_ST_XTGLB_zhenjiang_case_info.SUBJECT_RESULT_SATIFY as SUBJECT_RESULT_SATIFY,                           O_ST_XTGLB_zhenjiang_case_info.OPERATEDATE1 as OPERATEDATE1,                           O_ST_XTGLB_zhenjiang_case_info.REQUENCY as REQUENCY,                           O_ST_XTGLB_zhenjiang_case_info.OPERATEDATE as OPERATEDATE,                           O_ST_XTGLB_zhenjiang_case_info.THEME_SERIAL as THEME_SERIAL,                           O_ST_XTGLB_zhenjiang_case_info.CASE_HISTORYNUM as CASE_HISTORYNUM,                           O_ST_XTGLB_zhenjiang_case_info.CERTIFICATE_TYPE as CERTIFICATE_TYPE,                           O_ST_XTGLB_zhenjiang_case_info.CASE_GOAL as CASE_GOAL,                           O_ST_XTGLB_zhenjiang_case_info.EVENT_DATE as EVENT_DATE,                           O_ST_XTGLB_zhenjiang_case_info.CASE_ADDRESS as CASE_ADDRESS,                           O_ST_XTGLB_zhenjiang_case_info.CASE_EX_ACCORD as CASE_EX_ACCORD,                           O_ST_XTGLB_zhenjiang_case_info.CASE_EMOTION as CASE_EMOTION,                           O_ST_XTGLB_zhenjiang_case_info.CASE_LNGLAT as CASE_LNGLAT,                           O_ST_XTGLB_zhenjiang_case_info.CASE_AREA_CODE as CASE_AREA_CODE,                           O_ST_XTGLB_zhenjiang_case_info.RELATE_SERIAL as RELATE_SERIAL,                           O_ST_XTGLB_zhenjiang_case_info.TBACKTIME_BF as TBACKTIME_BF,                           O_ST_XTGLB_zhenjiang_case_info.TFDBACKTIME_BF as TFDBACKTIME_BF,                           O_ST_XTGLB_zhenjiang_case_info.TSIGNTIME_BF as TSIGNTIME_BF,                           O_ST_XTGLB_zhenjiang_case_info.CASE_SERIAL_TURN as CASE_SERIAL_TURN,                           O_ST_XTGLB_zhenjiang_case_info.AREA_CODE as AREA_CODE,                           O_ST_XTGLB_zhenjiang_case_info.CASE_MARK as CASE_MARK,                           O_ST_XTGLB_zhenjiang_case_info.CASE_ISURGENT as CASE_ISURGENT,                           O_ST_XTGLB_zhenjiang_case_info.CASE_ISVISIT as CASE_ISVISIT,                           O_ST_XTGLB_zhenjiang_case_info.CASE_ISPUBLIC as CASE_ISPUBLIC,                           O_ST_XTGLB_zhenjiang_case_info.CASE_PROCESS_TYPE as CASE_PROCESS_TYPE,                           O_ST_XTGLB_zhenjiang_case_info.CASE_CONTENT as CASE_CONTENT,                           O_ST_XTGLB_zhenjiang_case_info.CASE_ACCORD as CASE_ACCORD,                           O_ST_XTGLB_zhenjiang_case_info.CASE_TYPE as CASE_TYPE,                           O_ST_XTGLB_zhenjiang_case_info.APPLICANT_ID as APPLICANT_ID,                           O_ST_XTGLB_zhenjiang_case_info.APPLICANT_AGE as APPLICANT_AGE,                           O_ST_XTGLB_zhenjiang_case_info.APPLICANT_SEX as APPLICANT_SEX,                           O_ST_XTGLB_zhenjiang_case_info.APPLICANT_NAME as APPLICANT_NAME,                           O_ST_XTGLB_zhenjiang_case_info.PHONE_NUMBER as PHONE_NUMBER,                           O_ST_XTGLB_zhenjiang_case_info.CASE_SOURCE_DETAIL as CASE_SOURCE_DETAIL,                           O_ST_XTGLB_zhenjiang_case_info.CASE_SOURCE as CASE_SOURCE,                           O_ST_XTGLB_zhenjiang_case_info.CASE_DATE as CASE_DATE,                           O_ST_XTGLB_zhenjiang_case_info.CASE_REGISTERNO as CASE_REGISTERNO,                           O_ST_XTGLB_zhenjiang_case_info.CASE_REGISTER as CASE_REGISTER,                           O_ST_XTGLB_zhenjiang_case_info.CASE_TITLE as CASE_TITLE,                           O_ST_XTGLB_zhenjiang_case_info.CASE_SERIAL as CASE_SERIAL,                           O_ST_XTGLB_zhenjiang_case_info.ROWGUID as ROWGUID                         from                           (                             select                               *                             from                               O_ST_XTGLB_zhenjiang_case_info                           ) AS O_ST_XTGLB_zhenjiang_case_info                         union all                         select                           O_ST_XTGLB_changzhou_case_info.date_id,                           O_ST_XTGLB_changzhou_case_info.new_case_accord,                           O_ST_XTGLB_changzhou_case_info.case_accord_text,                           O_ST_XTGLB_changzhou_case_info.RELATION_POLICE_OFFICER,                           O_ST_XTGLB_changzhou_case_info.RELATION_DEPTS,                           O_ST_XTGLB_changzhou_case_info.RELATION_DEPTSCODE,                           O_ST_XTGLB_changzhou_case_info.ENTERPRISE_NAME,                           O_ST_XTGLB_changzhou_case_info.APPLICANT_TYPE,                           O_ST_XTGLB_changzhou_case_info.COMPLAINT_DETAIL,                           O_ST_XTGLB_changzhou_case_info.RQSTSOURCECHILD,                           O_ST_XTGLB_changzhou_case_info.ISKAOHE,                           O_ST_XTGLB_changzhou_case_info.flagguid,                           O_ST_XTGLB_changzhou_case_info.flag,                           O_ST_XTGLB_changzhou_case_info.FDBACK,                           O_ST_XTGLB_changzhou_case_info.SEND_TIME,                           O_ST_XTGLB_changzhou_case_info.FDBACKTIME,                           O_ST_XTGLB_changzhou_case_info.SIGN_TIME,                           O_ST_XTGLB_changzhou_case_info.HANDLETIME_LONG,                           O_ST_XTGLB_changzhou_case_info.FINISH_TYPE,                           O_ST_XTGLB_changzhou_case_info.FINISH_NOTE,                           O_ST_XTGLB_changzhou_case_info.FINISH_TIME,                           O_ST_XTGLB_changzhou_case_info.CONCACT_TIME,                           O_ST_XTGLB_changzhou_case_info.END_NAME,                           O_ST_XTGLB_changzhou_case_info.END_DEPT,                           O_ST_XTGLB_changzhou_case_info.VISIT_TYPE,                           O_ST_XTGLB_changzhou_case_info.VISIT_REMARK,                           O_ST_XTGLB_changzhou_case_info.SUBJECT_RESULT_SATIFY,                           O_ST_XTGLB_changzhou_case_info.OPERATEDATE1,                           O_ST_XTGLB_changzhou_case_info.REQUENCY,                           O_ST_XTGLB_changzhou_case_info.OPERATEDATE,                           O_ST_XTGLB_changzhou_case_info.THEME_SERIAL,                           O_ST_XTGLB_changzhou_case_info.CASE_HISTORYNUM,                           O_ST_XTGLB_changzhou_case_info.CERTIFICATE_TYPE,                           O_ST_XTGLB_changzhou_case_info.CASE_GOAL,                           O_ST_XTGLB_changzhou_case_info.EVENT_DATE,                           O_ST_XTGLB_changzhou_case_info.CASE_ADDRESS,                           O_ST_XTGLB_changzhou_case_info.CASE_EX_ACCORD,                           O_ST_XTGLB_changzhou_case_info.CASE_EMOTION,                           O_ST_XTGLB_changzhou_case_info.CASE_LNGLAT,                           O_ST_XTGLB_changzhou_case_info.CASE_AREA_CODE,                           O_ST_XTGLB_changzhou_case_info.RELATE_SERIAL,                           O_ST_XTGLB_changzhou_case_info.TBACKTIME_BF,                           O_ST_XTGLB_changzhou_case_info.TFDBACKTIME_BF,                           O_ST_XTGLB_changzhou_case_info.TSIGNTIME_BF,                           O_ST_XTGLB_changzhou_case_info.CASE_SERIAL_TURN,                           O_ST_XTGLB_changzhou_case_info.AREA_CODE,                           O_ST_XTGLB_changzhou_case_info.CASE_MARK,                           O_ST_XTGLB_changzhou_case_info.CASE_ISURGENT,                           O_ST_XTGLB_changzhou_case_info.CASE_ISVISIT,                           O_ST_XTGLB_changzhou_case_info.CASE_ISPUBLIC,                           O_ST_XTGLB_changzhou_case_info.CASE_PROCESS_TYPE,                           O_ST_XTGLB_changzhou_case_info.CASE_CONTENT,                           O_ST_XTGLB_changzhou_case_info.CASE_ACCORD,                           O_ST_XTGLB_changzhou_case_info.CASE_TYPE,                           O_ST_XTGLB_changzhou_case_info.APPLICANT_ID,                           O_ST_XTGLB_changzhou_case_info.APPLICANT_AGE,                           O_ST_XTGLB_changzhou_case_info.APPLICANT_SEX,                           O_ST_XTGLB_changzhou_case_info.APPLICANT_NAME,                           O_ST_XTGLB_changzhou_case_info.PHONE_NUMBER,                           O_ST_XTGLB_changzhou_case_info.CASE_SOURCE_DETAIL,                           O_ST_XTGLB_changzhou_case_info.CASE_SOURCE,                           O_ST_XTGLB_changzhou_case_info.CASE_DATE,                           O_ST_XTGLB_changzhou_case_info.CASE_REGISTERNO,                           O_ST_XTGLB_changzhou_case_info.CASE_REGISTER,                           O_ST_XTGLB_changzhou_case_info.CASE_TITLE,                           O_ST_XTGLB_changzhou_case_info.CASE_SERIAL,                           O_ST_XTGLB_changzhou_case_info.ROWGUID                         from                           (                             select                               *                             from                               O_ST_XTGLB_changzhou_case_info                           ) AS O_ST_XTGLB_changzhou_case_info                       ) AS bhb13                     union all                     select                       O_ST_XTGLB_nantong_case_info.ROWGUID,                       O_ST_XTGLB_nantong_case_info.CASE_SERIAL,                       O_ST_XTGLB_nantong_case_info.CASE_TITLE,                       O_ST_XTGLB_nantong_case_info.CASE_REGISTER,                       O_ST_XTGLB_nantong_case_info.CASE_REGISTERNO,                       O_ST_XTGLB_nantong_case_info.CASE_DATE,                       O_ST_XTGLB_nantong_case_info.CASE_SOURCE,                       O_ST_XTGLB_nantong_case_info.CASE_SOURCE_DETAIL,                       O_ST_XTGLB_nantong_case_info.PHONE_NUMBER,                       O_ST_XTGLB_nantong_case_info.APPLICANT_NAME,                       O_ST_XTGLB_nantong_case_info.APPLICANT_SEX,                       O_ST_XTGLB_nantong_case_info.APPLICANT_AGE,                       O_ST_XTGLB_nantong_case_info.APPLICANT_ID,                       O_ST_XTGLB_nantong_case_info.CASE_TYPE,                       O_ST_XTGLB_nantong_case_info.CASE_ACCORD,                       O_ST_XTGLB_nantong_case_info.CASE_CONTENT,                       O_ST_XTGLB_nantong_case_info.CASE_PROCESS_TYPE,                       O_ST_XTGLB_nantong_case_info.CASE_ISPUBLIC,                       O_ST_XTGLB_nantong_case_info.CASE_ISVISIT,                       O_ST_XTGLB_nantong_case_info.CASE_ISURGENT,                       O_ST_XTGLB_nantong_case_info.CASE_MARK,                       O_ST_XTGLB_nantong_case_info.AREA_CODE,                       O_ST_XTGLB_nantong_case_info.CASE_SERIAL_TURN,                       O_ST_XTGLB_nantong_case_info.TSIGNTIME_BF,                       O_ST_XTGLB_nantong_case_info.TFDBACKTIME_BF,                       O_ST_XTGLB_nantong_case_info.TBACKTIME_BF,                       O_ST_XTGLB_nantong_case_info.RELATE_SERIAL,                       O_ST_XTGLB_nantong_case_info.CASE_AREA_CODE,                       O_ST_XTGLB_nantong_case_info.CASE_LNGLAT,                       O_ST_XTGLB_nantong_case_info.CASE_EMOTION,                       O_ST_XTGLB_nantong_case_info.CASE_EX_ACCORD,                       O_ST_XTGLB_nantong_case_info.CASE_ADDRESS,                       O_ST_XTGLB_nantong_case_info.EVENT_DATE,                       O_ST_XTGLB_nantong_case_info.CASE_GOAL,                       O_ST_XTGLB_nantong_case_info.CERTIFICATE_TYPE,                       O_ST_XTGLB_nantong_case_info.CASE_HISTORYNUM,                       O_ST_XTGLB_nantong_case_info.THEME_SERIAL,                       O_ST_XTGLB_nantong_case_info.OPERATEDATE,                       O_ST_XTGLB_nantong_case_info.REQUENCY,                       O_ST_XTGLB_nantong_case_info.OPERATEDATE1,                       O_ST_XTGLB_nantong_case_info.SUBJECT_RESULT_SATIFY,                       O_ST_XTGLB_nantong_case_info.VISIT_REMARK,                       O_ST_XTGLB_nantong_case_info.VISIT_TYPE,                       O_ST_XTGLB_nantong_case_info.END_DEPT,                       O_ST_XTGLB_nantong_case_info.END_NAME,                       O_ST_XTGLB_nantong_case_info.CONCACT_TIME,                       O_ST_XTGLB_nantong_case_info.FINISH_TIME,                       O_ST_XTGLB_nantong_case_info.FINISH_NOTE,                       O_ST_XTGLB_nantong_case_info.FINISH_TYPE,                       O_ST_XTGLB_nantong_case_info.HANDLETIME_LONG,                       O_ST_XTGLB_nantong_case_info.SIGN_TIME,                       O_ST_XTGLB_nantong_case_info.FDBACKTIME,                       O_ST_XTGLB_nantong_case_info.SEND_TIME,                       O_ST_XTGLB_nantong_case_info.FDBACK,                       O_ST_XTGLB_nantong_case_info.flag,                       O_ST_XTGLB_nantong_case_info.flagguid,                       O_ST_XTGLB_nantong_case_info.ISKAOHE,                       O_ST_XTGLB_nantong_case_info.RQSTSOURCECHILD,                       O_ST_XTGLB_nantong_case_info.COMPLAINT_DETAIL,                       O_ST_XTGLB_nantong_case_info.APPLICANT_TYPE,                       O_ST_XTGLB_nantong_case_info.ENTERPRISE_NAME,                       O_ST_XTGLB_nantong_case_info.RELATION_DEPTSCODE,                       O_ST_XTGLB_nantong_case_info.RELATION_DEPTS,                       O_ST_XTGLB_nantong_case_info.RELATION_POLICE_OFFICER,                       O_ST_XTGLB_nantong_case_info.case_accord_text,                       O_ST_XTGLB_nantong_case_info.new_case_accord,                       O_ST_XTGLB_nantong_case_info.date_id                     from                       (                         select                           *                         from                           O_ST_XTGLB_nantong_case_info                       ) AS O_ST_XTGLB_nantong_case_info                   ) AS bhb20               ) AS bhb22           ) AS bhb23       ) z   ) a;
Expected behavior (Required)
run success
Real behavior (Required)
Memory exceed limit. Used:<PHONE_NUMBER>4, Limit:<PHONE_NUMBER>5
The Env is 2 be node, and every node is 8C16G
StarRocks version (Required)
2.0.0-GA

When Starrocks runs and mem exceed ， Can it run slow not error ? We can wait but it do not run error

When Starrocks runs and mem exceed ， Can it run slow not error ? We can wait but it do not run error

Please post the complete error message, when run the sql

Hi
We have 4 nodes, 16 Cores and 256Gb RAM
Could you say why we are getting problem ?
#from FE
2023-10-05 11:16:56,157 WARN (thrift-server-pool-1813661|1817786) [Coordinator.updateFragmentExecStatus():1571] exec state report failed status=errorCode MEM_LIMIT_EXCEEDED Memory of process exceed limit. try consume:25769803776 Used:<PHONE_NUMBER>56, Limit:<PHONE_NUMBER>15. Mem usage has exceed the limit of BE, query_id=0dda3354-633e-11ee-85a1-005056816cfa, instance_id=0dda3354-633e-11ee-85a1-005056816d16
2023-10-05 11:16:56,157 WARN (thrift-server-pool-1813661|1817786) [Coordinator.updateStatus():1374] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: 0dda3354-633e-11ee-85a1-005056816cfa, instance id: 0dda3354-633e-11ee-85a1-005056816d16
2023-10-05 11:16:56,157 INFO (thrift-server-pool-1813661|1817786) [Coordinator.cancelInternal():1495] unfinished instance: 0dda3354-633e-11ee-85a1-005056816d04
2023-10-05 11:16:56,168 WARN (thrift-server-pool-1813662|1817787) [Coordinator.updateFragmentExecStatus():1571] exec state report failed status=errorCode CANCELLED InternalError, query_id=0dda3354-633e-11ee-85a1-005056816cfa, instance_id=0dda3354-633e-11ee-85a1-005056816d0d
2023-10-05 11:16:56,170 WARN (thrift-server-pool-1813662|1817787) [Coordinator.updateFragmentExecStatus():1571] exec state report failed status=errorCode CANCELLED InternalError, query_id=0dda3354-633e-11ee-85a1-005056816cfa, instance_id=0dda3354-633e-11ee-85a1-005056816d15
2023-10-05 11:16:56,170 WARN (starrocks-mysql-nio-pool-591|1817297) [Coordinator.getNext():1394] get next fail, need cancel. status errorCode CANCELLED InternalError, query id: 0dda3354-633e-11ee-85a1-005056816cfa
2023-10-05 11:16:56,170 WARN (starrocks-mysql-nio-pool-591|1817297) [Coordinator.getNext():1420] query failed: Memory of process exceed limit. try consume:25769803776 Used:<PHONE_NUMBER>56, Limit:<PHONE_NUMBER>15. Mem usage has exceed the limit of BE
2023-10-05 11:16:56,170 INFO (starrocks-mysql-nio-pool-591|1817297) [QeProcessorImpl.unregisterQuery():105] deregister query id 0dda3354-633e-11ee-85a1-005056816cfa
2023-10-05 11:16:56,170 INFO (starrocks-mysql-nio-pool-591|1817297) [StmtExecutor.execute():654] execute Exception, sql: select Now(), count(1) from dwh.S02_Z#KAS_PC_FO_ZZ2 fo --40075374236   KAS. PC. Фактические операции (TYPE) ^M
join dwh.S02_Z#KAS_PC_DOG dog on  dog.c_fo_arr = fo.collection_id --50326168 KAS. PC. Договор карты (PRODUCT) ^M
left join dwh.S02_Z_MAIN_DOCUM doc on  fo.c_doc_ref = doc.id --46480977284 !Платежные документы (DOCUMENT) ^M
where fo.id in (select x.id from dwh.S02_S$Z#KAS_PC_FO_ZZ2 x where x.target_commit_date >= DATE_ADD(date('2023-10-03'),-1)), error: Memory of process exceed limit. try consume:25769803776 Used:<PHONE_NUMBER>56, Limit:<PHONE_NUMBER>15. Mem usage has exceed the limit of BE
2023-10-05 11:16:56,171 INFO (thrift-server-pool-1813663|1817788) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816d04, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
2023-10-05 11:16:56,172 INFO (thrift-server-pool-1813661|1817786) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816cfe, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
2023-10-05 11:16:56,173 INFO (thrift-server-pool-1813664|1817789) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816d17, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
2023-10-05 11:16:56,173 INFO (thrift-server-pool-1813664|1817789) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816d13, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
2023-10-05 11:16:56,173 INFO (thrift-server-pool-1813665|1817790) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816d0c, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
2023-10-05 11:16:56,173 INFO (thrift-server-pool-1813664|1817789) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816cfd, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
2023-10-05 11:16:56,173 INFO (thrift-server-pool-1813665|1817790) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816d06, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
2023-10-05 11:16:56,177 INFO (thrift-server-pool-1813662|1817787) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816cfb, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
2023-10-05 11:16:56,177 INFO (thrift-server-pool-1813662|1817787) [QeProcessorImpl.reportExecStatus():145] ReportExecStatus() failed, query does not exist, fragment_instance_id=0dda3354-633e-11ee-85a1-005056816d03, query_id=0dda3354-633e-11ee-85a1-005056816cfa,
#from BE
W1005 11:16:55.566022 35537 pipeline_driver.cpp:696] fragment_id 0dda3354-633e-11ee-85a1-005056816d0b driver query_id=0dda3354-633e-11ee-85a1-005056816cfa fragment_id=0dda3354-633e-11ee-85a1-005056816d0b driver=0x7ff9b1213b10, status=INPUT_EMPTY, operator-chain: [exchange_source_9_0x7ff9b1212490(O) -> hash_join_build_10_0x7ff9b1213110(X)(HashJoiner=0x7ff9b1212e90)] cancels operator hash_join_build_10_0x7ff9b1213110(X)(HashJoiner=0x7ff9b1212e90) with finished error Memory of process exceed limit. try consume:3221225472 Used:<PHONE_NUMBER>92, Limit:<PHONE_NUMBER>15.  Mem usage has exceed the limit of BE
Where is set this Limit:<PHONE_NUMBER>15 ?