title: mySQL JOIN usage
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause">INNER JOIN ON vs WHERE clause</a>  </p>
  </blockquote>
  
  
  
  <p>I started as web developer about 1 year ago. Since then I've gone through PHP, mySQL, Javascript, jQuery, etc. I think I've learned some things in this time. But when it comes to SQL I'm a real noob. I just do a couple of SELECT, INSERT, UPDATE, and using some functions like SUM or UNIX_TIMESTAMP, etc.</p>
  
  <p>I've come across the JOIN functions, and it seems to be pretty useful, but I don't see the difference of using JOIN or some WHERE clauses to "join" the data betwwen tables.</p>
  
  <p>I read <a href="http://mauriciopastrana.com/gadgets-y-tecnologia/entendiendo-los-mysql-join/" rel="nofollow noreferrer">this article</a> (spanish) about join. and I can't really see the usefulness of it. For example:</p>
  
  <p>Assuming this dataset:</p>
  
  <pre><code>id nombre       id  nombre
  -- ----         --  ----
  1  Pirata       1   Rutabaga
  2  Mico         2   Pirata
  3  Ninja        3   Darth Vader
  4  Spaghetti    4   Ninja
  </code></pre>
  
  <p>Wouldn't this query: <code>SELECT * FROM TablaA INNER JOIN TablaB ON TablaA.name = TablaB.name</code> produce the same results as <code>SELECT * FROM TablaA, TablaB WHERE TablaA.name = TablaB.name</code> ?</p>