ID_, APP_CATALOGS_ID_, NAME_, CODE_, DESCRIPTION_, SOURCE_TYPE_, LEVEL_, TABLE_CLASS, TABLE_TYPE_, TABLE_NAME_CH_, TABLE_NAME_EN_, TABLE_DESC_, TABLE_CODE_, IS_CREATE_TABLE_, CREATE_TABLE_SQL_, UPDATE_RATE_, FIELD_TOTAL, TOTAL_NUM_, INCREMENT_MAXTIME_, DATAFILE_DOWN_URL_, SN_, DEPLOYED_, DEPLOYED_TIME_, IS_DELE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_ORG_ID_, UPDATE_TIME_, TENANT_ID_ update BIZ_APP_CATALOGS_TABLE set APP_CATALOGS_ID_ = #{catalogId} where ID_ in #{id} select t.* from BIZ_APP_CATALOGS_TABLE t inner join BIZ_SCHEDULER_JOB_TABLE jt on t.id_=jt.TABLE_ID_ where jt.JOB_ID_=#{jobId}