title: SQL Server 2012 Multi part identifier could not be bound
body: <p>I have 4 tables I'm joining in Adventureworks 2012.  I cant figure out why I'm getting the 'could not be bound error'.</p>
  
  <blockquote>
    <p>Msg 4104, Level 16, State 1, Line 7</p>
    
    <p>The multi-part identifier "Production.ProductCategory.Name" could not be bound.</p>
    
    <p>Msg 4104, Level 16, State 1, Line 1</p>
    
    <p>The multi-part identifier "Production.ProductCategory.Name" could not be bound.</p>
  </blockquote>
  
  <pre><code>SELECT
      COUNT(WorkOrderID) AS TotalWorkOrders, 
      [Production].[ProductCategory].[Name]
  FROM [Production].[WorkOrder] WO
  INNER JOIN [Production].[Product] P ON WO.[ProductID] = P.[ProductID]
  INNER JOIN [Production].[ProductSubcategory] PS ON PS.[ProductSubcategoryID] = P.[ProductSubcategoryID]
  INNER JOIN [Production].[ProductCategory] PC ON PC.[ProductCategoryID] = PS.[ProductCategoryID]
  WHERE WO.[StartDate] &gt;= '1999—03-08' AND WO.[StartDate] &lt;= '2008-05-02'
  GROUP BY [Production].[ProductCategory].[Name]
  </code></pre>