Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update single column from another table
Message
 
 
To
28/11/2001 16:40:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00587103
Message ID:
00587210
Views:
27
Hi Jay,
Sorry but I'm not at all familiar with xBase commands
or what it is for that matter. Could you possibly describe
to me what steps to take?
Thanks
Max

>>I'm a victim of false memories! Sergey was right -- no join between 2 tables >>is possible with UPDATE.

>>I'd suggest using good ol' xBase commands.

>>Set the relation between T1 and T2 based on an index of the PK values (name >>and date). Then do a REPLACE ALL t2.commission WITH t1.commission.

>>Best wishes, and sorry for the bad lead.

>>Jay
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform