<div>
Much appreciated peter57r. &nbsp;That explains it and what I needed to confirm.<br />
<br />
ET
</div>


Much appreciated peter57r.  That explains it and what I needed to confirm.

ET

<div>
Appreciate the quick response.
</div>


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

</div>
</div>


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];


Thanks,

ET 


SQL WHERE Clause Question??

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.