title: Right join with a where clause
body: <p>I found a query like this in code:</p>
  
  <pre><code> SELECT *
     FROM a
          RIGHT JOIN b ON a.id = b.id
    WHERE a.id = b.id
  </code></pre>
  
  <p>Is it basically the same as an inner join on a.id = b.id?</p>