title: Is there alternative to inner join
body: <p>Is there something different between this two codes</p>
  
  <pre><code>select a.firstname,
         a.lastname,
         b.salary,
         b.designation
  from table a,
       table b
  where a.id = b.id
  </code></pre>
  
  <p>and </p>
  
  <pre><code>select a.firstname,
         a.lastname,
         b.salary,
         b.designation
  from table a inner join table b on a.id = b.id
  </code></pre>