title: Nested sql joins process explanation needed
body: <p>I want to understand the process of nested join clauses in sql queries. Can you explain this example with pseudo codes? (What is the order of joining tables?)</p>
  
  <pre><code>  FROM 
  table1 AS t1 (nolock)
      INNER JOIN table2 AS t2 (nolock)
          INNER JOIN table3 as t3 (nolock)
          ON t2.id = t3.id
      ON t1.mainId = t2.mainId
  </code></pre>