Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update tables
Message
From
06/12/2002 02:48:24
 
 
To
06/12/2002 02:28:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00730212
Message ID:
00730214
Views:
20
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform