只需要知道询价单号即可: — 根据报价单主表id更新update cpu_sourcing.cpu_qtoffer_detail set unpd_released = true where cpuofferid in ( select id from cpu_sourcing.cpu_qtoffer where vbuyoffer_billcode = ‘XJ2207080051’ and dr = ‘0’)