1. I have 2 tables .dbf , i want to replace the values of field1 of table1 from the field1 of the table2, how can i do it in a SINGLE COMMAND? i can use a sql command of visual foxpro?

2. And only just to know ...if i want to do the same with SQL SERVER tables ,there is any way of do it with an sql transact command of SQL SERVER ?

Thank you in advance

Luis Martin