mysql关联表修改

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