title: The multi-part identifier could not be bound in SQL Server and it confused
body: <p>I have this SQL query:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT 
      stu.sno, sname, cname
  FROM
      sc scc,
      (SELECT AVG(sc.grade) AS avg_grade 
       FROM sc 
       GROUP BY sc.cno) AS avg_grades
  INNER JOIN 
      course c ON c.cno = scc.cno
  INNER JOIN 
      s stu ON stu.sno = scc.sno;
  </code></pre>
  <p>And there is an error that the multi-part identifier <code>scc.cno</code> could not be bound. I'm confused - could someone help me?</p>