update xx inner join xx
on xx.smokeno=xx.SmokeNo
set xx.SmokeVehicleID=xx.SmokeVehicleID
where xx.SmokeNo='B4419000050220211109092449'
update xx inner join xx
on xx.smokeno=xx.SmokeNo
set xx.SmokeVehicleID=xx.SmokeVehicleID
where xx.SmokeNo='B4419000050220211109092449'