title: Unknown SQL syntax
body: <p>I'm following an SQL course and I'm having troubles understanding an example given my our professor, there's usually a lot of mistakes in our sheets that we have to correct but here I think it might just come from my obvious ignorance of the subject.</p>
  
  <p>So the database contains three tables organized like this:</p>
  
  <pre><code>Student (StudentNumber, Name, Year)
  Course (Code, Name, Hours)
  Results (StudentNumbber, Code, Grade)
  </code></pre>
  
  <p>We're asked to give the student numbers that follow the "M11104" coded course with one query to the database servor.
  Here is the solution given:</p>
  
  <pre><code>Select S. *
  FROM Student S, Results R
  WHERE Code = 'M1105'
  AND S.StudentNumber = R.StudentNumber;
  </code></pre>
  
  <p>I just don't get how is this supposed to work, first of all the <code>S</code> and <code>R</code> are no real attributes to the database given, and the <code>SELECT S.*</code> doesn't seem to mean anything there.</p>