Recent content by Tarebare30

Actually .. thank you to anyone who was going to help but I finally got it! I was making my life too complicated. For anyone else who is looking for a similar answer, the following worked: UPDATE Allocations INNER JOIN AllZones ON Allocations.Building_Name = AllZones.Building_Name SET...

Hi I'm trying to update field TT_Zone from table Allocations with the values in field TT_Zone from table AllZones. I have written this query: UPDATE Allocations SET Allocations.TT_Zone = AllZones.TT_Zone FROM Allocations INNER JOIN AllZones ON Allocations.Building_Name =...