>Hi,
>
>Here is my situation:
>
>I am working with 9x9 boxes of blood specimens stored in -80 freezers. The boxes have been consolidated into various new locations in the freezers. Box locations are described by freezer, shelf, rack and position. I want to use the Update - sql command to modify the locations for my boxes in the Box table using the NewLocation table.
>
>I think I am close but something is wrong with my syntax:
>
>

>update Box ;
>  set ;
>  Box.freezer  = NewLocation.freezer, ;
>  Box.shelf    = NewLocation.shelf, ;
>  Box.rack     = NewLocation.rack, ;
>  Box.position = NewLocation ;
>  from NewLocation ;
>  where Box.box = NewLocation.box
>

>
>Here is what help says:
>
>

>UPDATE Target
>   SET Column_Name1 = eExpression1 [, Column_Name2 = eExpression2 ...]
>   [FROM [FORCE] Table_List_Item [[, ...] | [JOIN [ Table_List_Item]]]
>   WHERE FilterCondition1 [AND | OR FilterCondition2 ...]
>
>

>
>I am sure it is pretty obvious, let me know if you see my error ...
>
>Thanks!

First, UPDATE ... FROM is supported on VFP9 only.

Second, the sql command is incomplete:

update Box ;
  set ;
  Box.freezer  = NewLocation.freezer, ;
  Box.shelf    = NewLocation.shelf, ;
  Box.rack     = NewLocation.rack, ;
  Box.position = NewLocation.position ; && !!!!!
  from NewLocation ;
  where NewLocation.box = Box.box