Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to: SQL update statement
Message
From
20/09/2002 16:46:24
 
 
To
19/09/2002 15:45:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00702283
Message ID:
00702932
Views:
15
I'll try that. I hadn't thought of using the LOOKUP() command. I have not ever used it before.

>Jim,
>
>Try the following:
>
>REPLACE ALL Table1.MyColumn WITH LOOKUP(Table2.myMatchedColumn, Table1.KeyId, Table2.KeyId)
>
>
Jim Newsom
IT Director, ICG Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform