title: Do join constraints in a SQL right join do anything?
body: <p>I just had to fix a query that was doing a RIGHT JOIN with an additional constraint on the right hand side: <code>RIGHT JOIN b ON b.key = a.key AND b.active = 'Y'</code></p>
  
  <p>It appeared to be completely ignoring the <code>b.active</code> constraint. Is that a limitation of RIGHT JOIN? I swapped the tables over and moved the <code>b.active</code> constraint into the WHERE, I've never liked RIGHT JOIN and I think this has reinforced my aversion to it.</p>