title: Yes another - The multi-part identifier "xxx" could not be bound
body: <p>Ok, here is my Query:</p>
  
  <pre><code>SELECT DISTINCT
      CS.CPL_Schedule_Id          AS CplScheduleId
      ,S.Schedule_Status_Id       AS ScheduleStatusId
      ,S.Record_Created           AS Created
  FROM CPL_Schedule CS
      JOIN (
              SELECT TOP 1 CSL.CPL_Schedule_ID, CSL.Record_Created, CSL.Schedule_Status_Id
              FROM CPL_Schedule_Audit_Log CSL
              WHERE CSL.CPL_Schedule_ID = CS.CPL_Schedule_ID
              ORDER BY Record_Created DESC
          ) S
          ON S.CPL_Schedule_ID = CS.CPL_Schedule_ID
  WHERE 
      CS.Exhibitor_Id = 1 
  </code></pre>
  
  <p>And I am getting the error on this line <code>WHERE CSL.CPL_Schedule_ID = CS.CPL_Schedule_ID</code></p>
  
  <blockquote>
    <p>The multi-part identifier "CS.CPL_Schedule_ID" could not be bound.</p>
  </blockquote>
  
  <p>To me it looks like this is saying that nested query does not know about CS, is that true?  What am I missing here?  Help is much appreciated, thank you!</p>