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!
Carole Shaw
Fred Hutchinson Cancer Research Center
Eagles may soar, but weasels don't get sucked into jet engines.