title: LEFT JOIN query not returning all rows in first table
body: <p>Using management studio for <code>SQL Server 2008 R2</code>.</p>
  
  <p>Trying to do a <code>LEFT JOIN</code> and I need to return all rows from the first table regardless of the row being able to tie with the second table.
  Not sure I explained that right.</p>
  
  <p>This is what I got right now:</p>
  
  <pre><code>select a.id, a.name, b.store, b.stock
  from products a left join stock b
  on a.id = b.id
  where b.store = '001'
  order by a.id
  </code></pre>
  
  <p>I need the query to return all products that the company sells and also show it's stock in store <code>001</code>.</p>
  
  <p>But the way it is right now it will only show the rows that have mention of the product stock in store <code>001</code>.</p>
  
  <p>So, basically, I need the query to return <code>0</code> stock if the <code>001</code> store is not mentioned.</p>
  
  <p>All products that only have stock in store <code>002</code> need to be listed as well, with a <code>0</code> as it's stock.</p>