title: Join 3 Tables in SQL Server 2008
body: <p>I'm trying to join 3 tables together with an inner join. Tables prod_num and usrs are relted by usr_Id and tables usrs and usr_Data are related by usr_Num. So tables 1 and 3 are not related in between so I want to realte the result of joining 1 and 2 with table 3 this is what im trying to do:</p>
  
  <pre><code>USE Puzzle
  SELECT a.Name, a.Id, b.Id, c.Email
  FROM prod_num a INNER JOIN usrs b
  ON a.usr_Num = b.usr_Num&lt;br&gt;FROM usrs b INNER JOIN usr_Data c
  ON b.usr_Id = c.usr_Id
  </code></pre>
  
  <p>How can I do a Join from a result of a previous Join?</p>