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.
jamesh1031Asked:
Who is Participating?
 
AustinSevenConnect With a Mentor Commented:
update Tbl_Movements
set RelatedInventoryID  = RelatedMoveID,  RelatedMoveID = NULL

AustinSeven
0
 
Scott PletcherSenior DBACommented:
UPDATE Tbl_Movements
SET RelatedInventoryID = RelatedMoveID
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.