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 =...