Sql to Update table from another table 1

[Dashley]

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

 

[simian336]

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

 

[Dashley]

Thanks Simian,

Worked Great I appreciate it

-dan