This will only update record(s) in table1 that have the same id as current record in the table2.

>Replace all table1.price1 with table2.price2 For table1.id1 = table2.id2
>
>
>
>>hi all
>>i have two tables
>>table1->id1,price1
>>table2->id2,price2
>>i want update table1(price1) by table2(price2) if id1=id2 by sql and not by view or programing with do while ..........and ....
>>my tables are in visual foxpro and not in lower version
>>how do it?
>>tanks