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
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.