title: Can't make a common table expression with join
body: <p>For some reason I can't make a CTE from the query:</p>
  
  <pre><code>SELECT LetterGrade, ES.Classification 
  FROM Enrollment AS EN 
  JOIN Students AS ES ON EN.StudentID = ES.StudentID
  </code></pre>
  
  <p>This statement:</p>
  
  <pre><code>WITH [DERIVED] AS
  (
      SELECT LetterGrade, ES.Classification 
      FROM Enrollment AS EN 
      JOIN Students AS ES ON EN.StudentID = ES.StudentID
  )
  </code></pre>
  
  <p>raises the error: </p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 5<br>
    Incorrect syntax near ')'</p>
  </blockquote>
  
  <p>Any ideas?</p>