Using the SQL shown below, I'm basically joining the Route tbl to the TempRouteImport tbl and updating a field called AREA. I generally do this in VBA code and I want to use more SQL in this particular application. The question is, should a WHERE clause be included (WHERE ROUTE.ROUTE_NUMBER = TempRouteImport.ROUTE_NUMBER) or does the join handle this??? It seems to work properly without the WHERE but I just want to make sure.
UPDATE ROUTE INNER JOIN TempRouteImport ON ROUTE.ROUTE_NUMBER = TempRouteImport.ROUTE_NUMBER SET ROUTE.AREA = [TempRouteImport]![AREA];