title: Cannot run a natural join
body: <p>I have two tables:</p>
  
  <ul>
  <li>A table <code>takes</code> with attributes <code>ID</code> and <code>Course_ID</code></li>
  <li>A table <code>course</code> with attributes <code>Course_ID</code>, <code>title</code>, and <code>dept_name</code></li>
  </ul>
  
  <p>I want to retrieve <code>title</code> and <code>dept_name</code> using a natural join on the two tables, but it returns an error:</p>
  
  <blockquote>
    <p>incorrect syntax near ';'</p>
  </blockquote>
  
  <p>My code:</p>
  
  <pre><code>select title, dept_name
  from takes 
  natural join course;
  </code></pre>
  
  <p>What is wrong with my code? </p>
  
  <p>PS. My textbook does not mention using the <code>on</code> keyword. Besides that, it also mentions to use the operator <code>using</code> to specify the common attributes, but this doesn't help either.</p>