title: When to use SQL natural join instead of join .. on?
body: <p>I'm studying SQL for a database exam and the way I've seen SQL is they way it looks on this page:</p>
  
  <p><a href="http://en.wikipedia.org/wiki/Star_schema" rel="nofollow">http://en.wikipedia.org/wiki/Star_schema</a>
  IE <code>join</code> written the way <code>Join &lt;table name&gt; On &lt;table attribute&gt;</code> and then the join condition for the selection. My course book and my exercises given to me from the academic institution however, use only natural join in their examples. So when is it right to use natural join? Should natural join be used if the query can also be written using JOIN .. ON ?</p>
  
  <p>Thanks for any answer or comment</p>