title: In T-SQL what is the best design for multiple INNER JOINs?
body: <p>I have looked for a similar issue to no avail. If I have missed the solution, my apologies and please point me in the right direction.</p>
  
  <p>I have be playing with MS AdventureWorks and would like to know if there is any functional difference between two SELECT statements using INNER JOIN that I have created. They give the same results.</p>
  
  <p><strong>Version 1</strong></p>
  
  <pre><code>SELECT  pp.BusinessEntityID, pp.FirstName, pp.MiddleName, pp.LastName, pp.Suffix, 
      pe.EmailAddress, 
      pa.AddressLine1, pa.AddressLine2, pa.City, pa.PostalCode FROM 
  Person.BusinessEntityAddress AS bea 
  INNER JOIN  Person.Address AS pa 
      ON bea.AddressID = pa.AddressID 
  INNER JOIN  Person.Person AS pp 
      ON bea.BusinessEntityID = pp.BusinessEntityID   
  INNER JOIN  Person.EmailAddress AS pe 
      ON pp.BusinessEntityID = pe.BusinessEntityID 
  WHERE pp.Suffix IS NOT NULL
  </code></pre>
  
  <hr>
  
  <p><strong>Version 2</strong></p>
  
  <pre><code>SELECT      pp.BusinessEntityID, pp.FirstName, pp.MiddleName, pp.LastName, pp.Suffix,
          pe.EmailAddress,
          pa.AddressLine1, pa.AddressLine2, pa.City, pa.PostalCode 
  FROM        Person.BusinessEntityAddress AS bea 
          INNER JOIN Person.Address AS pa 
              ON bea.AddressID = pa.AddressID 
          INNER JOIN Person.Person AS pp 
              ON bea.BusinessEntityID = pp.BusinessEntityID
          INNER JOIN Person.EmailAddress AS pe 
              ON bea.BusinessEntityID = pe.BusinessEntityID 
  WHERE     pp.Suffix IS NOT NULL
  </code></pre>
  
  <p>The only difference is in the last ON clause. The design diagrams look quite different though
  Any thoughts would be very welcome</p>