title: How to select from mutiple tables with partial dependency?
body: <p>I have two tables in my SQL Server 2008. One is the item list and the other is item flow like this:</p>
  
  <p>Item table:</p>
  
  <pre><code>item_id   item_name
  --------------------
        1       item1
        2       item2
        3       item3
  </code></pre>
  
  <p>and flow table:</p>
  
  <pre><code>date        item_id   qty
  -------------------------
  2014-10-15        1     5
  2014-10-15        2     3
  2014-10-16        1     7
  2014-10-17        1     4
  2014-10-17        2     2
  2014-10-17        3     1
  </code></pre>
  
  <p>How can I keep select every data in item table with no record in flow table so I can get result like this:</p>
  
  <pre><code>date        item   qty
  -----------------------
  2014-10-15  item1    5
  2014-10-15  item2    3
  2014-10-15  item3    0
  2014-10-16  item1    7
  2014-10-16  item2    0
  2014-10-16  item3    0
  2014-10-17  item1    4
  2014-10-17  item2    2
  2014-10-17  item3    1
  </code></pre>