Search results

  1. T

    UPDATE with INNER JOIN

    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...
  2. T

    UPDATE with INNER JOIN

    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 =...
Back
Top Bottom