CODEWITHSUNDEEP
foxpro
user1454535
user1454535

Reputation: 33

visual foxpro - need to update table from another table

I have 2 dbf tables and I need to update the 1st table based from the 2nd table values. I am able to do it in SQL server and I need help on Visual Foxpro.

Here's my foxpro command:

=========================================================

use table1

use table2

UPDATE table1 

SET table1.name = table2.name 

from table1 inner join table2 

on table1.id = table2.id 

WHERE table1.dsdate >= {^2011-04-13} and table1.dsdate <= {^2012-04-12}

=========================================================

Please help me, thanks very much!

Upvotes: 2

Views: 15895

Answers (1)

Alan B
Alan B

Reputation: 4288

Update Table1 From table2 Where table1.id = table2.id ;
Set table1.name = table2.name

Upvotes: 9

Related Questions