jamesh1031
asked on
Move data from one column to another column in the same table.
I want to move the contents of a column RelatedMoveID to a column named RelatedInventoryID in a table named Tbl_Movements. Could you help me with what I assume will be an update query? Current values in RelatedInventoryID are all <NULL> and RelatedMoveID will be empty and Nulls are allowed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SET RelatedInventoryID = RelatedMoveID