update BIZ_DWD_CATALOGS_TABLE set DW_CATALOGS_ID_ = #{catalogId} where ID_ in #{id} select t.* from BIZ_DWD_CATALOGS_TABLE t inner join BIZ_SCHEDULER_JOB_TABLE jt on t.id_=jt.TABLE_ID_ where jt.JOB_ID_=#{jobId}