title: join three tables in sql server 2005
body: <p>I ve thus far used join with two tables but now i want to join three tables which is shown in the below fig</p>
  
  <p><a href="https://i.stack.imgur.com/LLtHQ.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LLtHQ.gif" alt="alt text"></a><br>
  <sub>(source: <a href="http://i.msdn.microsoft.com/ms152507.75c9e4c3-260d-4b8d-8a27-b720d8f4470e%28en-US,SQL.90%29.gif" rel="nofollow noreferrer">microsoft.com</a>)</sub>  </p>
  
  <p>I ve tried to join two tables,</p>
  
  <pre><code>SELECT O.OrderID,O.CustID,O.OrderTotal,C.Name from Orders
  as O inner join Customers as C on O.CustID=C.CustID 
  </code></pre>
  
  <p>how to join the third table with this.... Any suggestion...</p>