This May Help

update ventven

set priori= (select toer from toerok on ventven.ship=toerok.nomat)

WHERE ventven.codaff IN ('tale','talk','tbre','tdle','tdlk','tdpe','tele','tepe')

Chris