title: MySQL: Quick breakdown of the types of joins
body: <p>I would like a quick breakdown of the types of MySQL joins. I know of these, the rest I am not sure what they mean.</p>
  
  <ul>
  <li>comma separated (what <em>exactly</em> is this short for?): <code>SELECT * FROM a, b WHERE b.id = a.beeId AND ...</code></li>
  <li>show information from a, even if there are no matches in b: <code>SELECT * FROM a LEFT OUTER JOIN b ON b.id = a.beeId WHERE ...</code></li>
  </ul>
  
  <p>I have seen other joins, but want to know what makes them different, what is <code>INNER</code>/<code>OUTER</code>, does adding <code>LEFT</code> change things.</p>
  
  <p>I already know how joins work, I just want to know if there are other types of joins, or if they are just different ways to get the same result.</p>