>Hi Cetin
>
>>Maybe a third one:)
>
>*g*
>
>>I read that it's a kind of replace operation. First + an Update SQL with inner join might be faster,test.
>
>Yeah, a replace but in the local cursor for which the scan is all about. The SQL is parent / lookup for the local cursor.
Even a fourth one comest o mind. Why multiple replaces in a scan..endscan when one could do. ie:
select local
replace someField with remote.someField for seek(local.someKey,'remote','keytag')
Cetin