UPDATE SQL

[BRADLEY21]

I am trying to use the update command to update a field with data from another table.

example:

update mytable1 set field1 =(select field1 from table2 where mytable1.key1=mytable2.key1)

Of course the above will not work, just trying to get accross what I am trying to do.

Thanks

 

[Mike Gagnon]

I am trying to use the update command to update a field with data from another table.

update mytable1 set field1 =table2.field1 where mytable1.key1=mytable2.key1

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[BRADLEY21]

This is a VFP specif question as it relates to the native SQL of Foxpro

 

[BRADLEY21]

This is a VFP specific question as it relates to the native SQL of Foxpro

 

[Mike Gagnon]

This is a VFP specific question as it relates to the native SQL of Foxpro

Why? My suugestion doesn't work for you? Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first