Update SQL in Foxpro

[BRADLEY21]

This does not work in foxpro, for those who know what I am trying to do, your help would be appreciated.

UPDATE table_1;
SET field_1= (SELECT field_1;
FROM table_2;
WHERE table_2.key=table_1.key)

Thanks

 

[danceman]

according to the help file the set field = expects an expression. select SQL is not an expression that can be evaluated, it is a command. Attitude is Everything

 

[danceman]

SELECT field_1;
FROM table_2;
WHERE table_2.key=table_1.key INTO CURSOR junk

UPDATE table_1 SET field_1= junk.field_1 Attitude is Everything