View Single Post
  #2 (permalink)  
Old February 9th, 2011, 03:46 AM
melvik melvik is offline
Friend of Wrox
Points: 3,558, Level: 25
Points: 3,558, Level: 25 Points: 3,558, Level: 25 Points: 3,558, Level: 25
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: California, USA
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

well Im not sure about FoxPro (I used to work with DOS) but its the SQL
Code:
UPDATE TableA SET Column2 = B.Column2
FROM TableA A INNER JOIN TableB B ON A.Id = B.Id
or if im still remembering FoxPro, u cant use INNER so it might be sth like

Code:
UPDATE TableA SET Column2 = B.Column2
FROM TableA A ,TableB B
WHERE A.Id = B.Id
HtH
__________________
Always,
Hovik Melkomian.
Reply With Quote