UPDATE Table2 SET Table2.Folder_ID = Table1.Folder_ID WHERE Table1.Folder = Table2.Folder;