title: the multi-part identifier could not be bound - inner join of 5 tables - no subqueries
body: <p>I've been stuck on this error and the related questions found here on SO have not helped me see the light on this query:</p>
  
  <pre><code>SELECT 
   EventID = a.EventID
  ,PositionID = a.PositionID
  ,SubscriberID = a.SubscriberID
  ,EventTitle = a.EventTitle
  ,Frequency = a.Frequency
  ,DueDate = a.DueDate
  ,NoticeDate = a.NoticeDate
  ,SubscriberName = e.SubscriberName 
  ,PositionTitle = d.PositionTitle
  ,UserID = c.UserID
  ,UserName = c.UserName
  ,BackupUserID = b.BackupUserID
  FROM 
      dbo.tblEvent         a JOIN 
      dbo.PositionPeople   b JOIN
      dbo.UserInfo         c JOIN 
      dbo.Position         d JOIN
      dbo.Subscriber       e
  ON
  a.PositionID        = b.PositionID      AND
  a.SubscriberID      = b.SubscriberID    AND
  b.IncumbentUserID   = c.UserID          AND
  a.SubscriberID      = c.SubscriberID    AND
  a.SubscriberID      = e.SubscriberID    AND
  a.PositionID        = d.PositionID  
  </code></pre>
  
  <p>I'm not mixing implicit and explicit JOINs and not using a subquery as suggested by other threads on this topic. I get this error for everything following the ON clause above (except for e.SubscriberID and d.PositionID). I've tried several variations and I cannot spot the problem.   </p>