ID_, ODS_CATALOGS_ID_, CLUSTER_ID_, CLUSTER_TABLE_ID_, TABLE_PREFIX_CODE_, NAME_, CODE_, DESCRIPTION_, SOURCE_TYPE_, LEVEL_, SOURCE_, DB_SOURCE_ID_, TABLE_TYPE_, TABLE_NAME_CH_, TABLE_NAME_EN_, TABLE_DESC_, TABLE_CODE_, IS_CREATE_TABLE_, CREATE_TABLE_SQL_, UPDATE_RATE_, FIELD_TOTAL_, TOTAL_NUM_, SN_, DEPLOYED_, DEPLOYED_TIME_, IS_DELE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_ORG_ID_, UPDATE_TIME_, TENANT_ID_ update BIZ_ODS_CATALOGS_TABLE set ODS_CATALOGS_ID_ = #{catalogId} where ID_ in #{id} select * from BIZ_ODS_CATALOGS_TABLE t inner join BIZ_SCHEDULER_JOB_TABLE jt on t.id_=jt.TABLE_ID_ where jt.JOB_ID_=#{jobId}