title: SQL Server: join three tables
body: <p>I was able to join 2 SQL tables use the following query:</p>
  
  <pre><code>SELECT * 
  FROM Table1, Table2 with (nolock)
  WHERE Table1.field1 = Table2.field2
  </code></pre>
  
  <p>Then I tried to join 3 SQL tables like below:</p>
  
  <pre><code>SELECT * 
  FROM Table1, Table2, Table3 with (nolock)
  WHERE Table1.field1 = Table2.field2, Table1.field2 = Table3.field3
  </code></pre>
  
  <p>But it didn't work. Did I miss anything here? Or how do I join 3 tables properly?</p>
  
  <p>Thanks!</p>