Hi all,

This may sound like a dumb questions but it's driving me crazy. I have 2 cursors, 1 with 3 field (A,B and C) and the other one with 2 fields (A and C). Can i update the C field from cursor 1 with the data from C field of cursor 2 based on the key field A. The easiest way is of course to SET RELATION or do a SCAN SEEK REPLACE ENDSCAN. I'm just wondering if this can be done with 1 UPDATE SQL instruction ?

Thx for suggestions

Guillaume