A表某字段==B表某字段 更新A表的数据

    update  mls_supplytask t1 -- 供应商认证任务
            JOIN mls_sup_cert_report t2   -- 供应商认证报告
        on t1.id = t2.certTaskId set t1.isNoRept ='0'
        where t2.id = '711290394440105984' and t2.dr =1