title: SQL Server 2005: Multiple INNER JOIN expressions
body: <p>I'm having trouble with joining several tables to a main table. My first join is a LEFT OUTER JOIN, and it simply puts two tables together for 2 halves of a whole view (why they split the table has something to do with security). I've got several items on the main table stored as IDs, such as product_id, application_id, state_id and retailer_id. The names of each of these are stored on their own tables, as expected.</p>
  
  <p>My statement works fine with the LEFT OUTER JOIN and <strong>2</strong> INNER JOINs, however the statement stops returning data at <strong>3</strong> INNER JOINs. I don't know if there is a problem with how I've formed my INNER JOINs or what:</p>
  
  <pre><code>FROM ((((MyDbo.warranty w
      INNER JOIN MyDbo.products p1 ON w.product_id = p1.product_id)
      INNER JOIN MyDbo.applications ap1 ON w.application_id = ap1.application_id)
      INNER JOIN MyDbo.retailers r1 ON w.retailer_id = r1.retailer_id)
      INNER JOIN MyDbo.states s1 ON w.state_id = s1.state_id)
      LEFT OUTER JOIN MyDbo.warranty_info i on w.warranty_id = i.warranty_id
  </code></pre>
  
  <p>Am I way off base here?</p>