title: When to use a JOIN for MySQL (SQL)
body: <p>I cannot effectively understand the difference between these two queries.</p>
  
  <pre><code>select *
  from person p, mytlc m
  where p.personid = m.personid and p.personid = 3635
  
  select *
  from person p
      join mytlc m on p.personid = m.personid
  where p.personid=3635
  </code></pre>
  
  <p>In this case, I don't think either will be a greater performing query;but, what if the query was more complex handling much more data.</p>
  
  <p>Thanks!</p>