title: Getting All the record of particular month - Building SQL Query
body: <p>I need some help to build SQL Query. I have table having data like:</p>
  
  <pre><code>ID  Date        Name
  1   1/1/2009    a
  2   1/2/2009    b
  3   1/3/2009    c
  </code></pre>
  
  <p>I need to get result something like...</p>
  
  <pre><code>1    1/1/2009    a
  2   1/2/2009    b
  3   1/3/2009    c
  4   1/4/2009    Null
  5   1/5/2009    Null
  6   1/6/2009    Null
  7   1/7/2009    Null
  8   1/8/2009    Null
  ............................
  ............................
  ............................
  30  1/30/2009   Null
  31  1/31/2009   Null
  </code></pre>
  
  <p>I want query something like..</p>
  
  <pre><code>Select * from tbl **where month(Date)=1 AND year(Date)=2010**
  </code></pre>
  
  <p>Above is not completed query.</p>
  
  <p>I need to get all the record of particular month, even if some date missing..</p>
  
  <p>I guess there must be equi Join in the query, I am trying to build this query using Equi join</p>
  
  <p>Thanks</p>