SQL Join Order Optimization

[Dennis W. Bulgrien]

Given 2 joins to a query of keys, there are two ways they could be joined.

QueryKey to Table1 and QueryKey to Table2
-or-
QueryKey to Table1 and Table1 to Table2

Does anybody know if one way is better, more efficient, than the other?

 

[Van T. Dinh]

Not sure from your description (QUERYKey???) but see the
if the Microsoft Knowledgw Base article helps:

<http://support.microsoft.com/?id=209126>

HTH
Van T. Dinh
MVP (Access)