title: Difference between JOIN and INNER JOIN
body: <p>Both these joins will give me the same results:</p>
  
  <pre><code>SELECT * FROM table JOIN otherTable ON table.ID = otherTable.FK
  </code></pre>
  
  <p>vs</p>
  
  <pre><code>SELECT * FROM table INNER JOIN otherTable ON table.ID = otherTable.FK
  </code></pre>
  
  <p>Is there any difference between the statements in performance or otherwise? </p>
  
  <p>Does it differ between different <strong>SQL</strong> implementations? </p>