Tbl1, Tbl2, Tbl3.
TempTbl.
The fileds in Tb;1- Tbl3 that are to be updated would be ID.
TempTbl would have 2 fields: OldID, NewID
Expand|Select|Wrap|Line Numbers
- UPDATE Tbl1, Tbl2, Tbl3
- ((INNER JOIN TempTbl ON Tbl1.ID = TempTlb.OldID)
- (INNER JOIN TempTbl ON Tbl2.ID = TempTlb.OldID))
- INNER JOIN TempTbl ON Tbl3.ID = TempTlb.OldID
- SET Tbl1.ID = TempTbl.NewID,Tbl2.ID =
- TempTbl.NewID,Tbl3.ID = TempTbl.NewID;
Thank you.