title: LEFT JOIN on two tables
body: <p>I tried the following SQL query to load data from a database to PowerPivot model based on instructions from a PowerPivot manual:</p>
  
  <pre><code>SELECT
    Production_Product.Name AS Product,
    Production_ProductCategory.Name AS Category,
    Production_ProductSubcategory.Name AS SubCategory
  FROM
    Production_Product
    LEFT OUTER JOIN Production_ProductSubcategory
      ON Production_Product.ProductSubcategoryID = Production_ProductSubcategory.ProductSubcategoryID
    LEFT OUTER JOIN Production_ProductCategory
      ON Production_ProductSubcategory.ProductCategoryID = Production_ProductCategory.ProductCategoryID
  </code></pre>
  
  <p>Unfortunatelly it keeps throwing a syntax error (missing operator) and I can't find what went wrong. It worked perfectly with only one (first) inner join.</p>