Hi all,

I have a template table :

template.dbf
empno balance

11111
22222
33333
44444

with the data from temporarily table:

temptable.dbf
empno balance

11111 10000
44444 20000

to update the above template.dbf table to have the results finally as:

template.dbf
empno balance

11111 10000
22222 0
33333 0
44444 20000

TIA.