title: SQL Left join - Fixed value from Right table
body: <p>I have 2 tables say A and B. As part of the existing process, it works something like this</p>
  
  <pre><code>Select A.a, B.b
  from A left join B
  on A.c=B.C
  and B.b = 'xyz'
  </code></pre>
  
  <p>Now, due to a specific requirement, I need to have B.b = 'xyz' in the where clause. Something like this</p>
  
  <pre><code>Select A.a, B.b
  from A left join B
  on A.c=B.C
  where B.b = 'xyz'
  </code></pre>
  
  <p>But as soon as I do this, It works as an inner join.</p>
  
  <p>How shall I tweak my query such that I get the desired output using the where clause.</p>