只需要知道询价单号即可:

    — 根据报价单主表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’
    )