title: SQL Query error: The multi-part identifier ... could not be bound
body: <p>I'm sure this is obvious but I can't seem to figure out why I'm getting the error.</p>
  
  <p>"Msg 4104, Level 16, State 1, Line 1
  The multi-part identifier "dbo.ProductCode.ProductCode" could not be bound."</p>
  
  <p>I'm joining many tables base on the "Name" column in each table, but in this case I need to link ProductCodeReference.ProductCode to ProductCode.ProductCode and pull ProductCodeReference.ProductName based on ProductCode.Name</p>
  
  <pre><code>SELECT 
  dbo.Servers.Name, 
  dbo.ProductCodeReference.ProductName,
  dbo.Enclosure.Model, 
  dbo.OperatingSystem.FullOS, dbo.OperatingSystem.osbit,
  dbo.OperatingSystem.ServicePack, dbo.OperatingSystem.Version,
  dbo.Processor.Processors, dbo.Processor.CoreCount,
  dbo.Memory.capacity,
  dbo.MarcLevel.marcLevel
  FROM dbo.Servers
  
  INNER JOIN dbo.ProductCodeReference
  ON dbo.ProductCode.ProductCode=dbo.ProductCodeReference.ProductCode
  
  INNER JOIN dbo.Enclosure
  ON dbo.Servers.Name=dbo.Enclosure.Name
  
  INNER JOIN dbo.OperatingSystem
  ON dbo.Servers.Name=dbo.OperatingSystem.Name
  
  INNER JOIN dbo.Processor
  ON dbo.Servers.Name=dbo.Processor.Name
  
  INNER JOIN dbo.Memory
  ON dbo.Servers.Name=dbo.Memory.name
  
  INNER JOIN dbo.MarcLevel
  ON dbo.Servers.Name=dbo.MarcLevel.name
  
  ORDER BY dbo.Servers.Name
  </code></pre>
  
  <p>Hopefully that makes sense. Thanks!</p>