Dec 21, 2016 #1 Dashley Programmer Joined Dec 5, 2002 Messages 925 Location US Hi I have two tables Tbl1 Name = Memos Memo (text) MemoID (Int) Tb22 Name members lastname (nvarchar(50)) firstname (nvarchar(50)) oldindx (int) indx (int) I want to update/set TB1.memoID = Tbl2.indx BTW TBL1.memoid = tbl2.oldindx Thanks -dan
Hi I have two tables Tbl1 Name = Memos Memo (text) MemoID (Int) Tb22 Name members lastname (nvarchar(50)) firstname (nvarchar(50)) oldindx (int) indx (int) I want to update/set TB1.memoID = Tbl2.indx BTW TBL1.memoid = tbl2.oldindx Thanks -dan
Dec 21, 2016 1 #2 simian336 Programmer Joined Sep 16, 2009 Messages 723 Location US If I am seeing everything... update tbl1 set TBl1.memoID = Tbl2.indx from tbl1 join tbl2 on TBL1.memoid = tbl2.oldindx You might want to backup TBL1 first. Simi Upvote 0 Downvote
If I am seeing everything... update tbl1 set TBl1.memoID = Tbl2.indx from tbl1 join tbl2 on TBL1.memoid = tbl2.oldindx You might want to backup TBL1 first. Simi
Dec 21, 2016 Thread starter #3 Dashley Programmer Joined Dec 5, 2002 Messages 925 Location US Thanks Simian, Worked Great I appreciate it -dan Upvote 0 Downvote