title: Count all if even zero
body: <p>I have this SQL</p>
  
  <pre><code>SELECT count(*) AS TotalOrders, [Sell-to Customer No_], [Document Date] 
  FROM [Navision4].[dbo].[3S Company A_S$Sales Invoice Header]  
    INNER JOIN [Navision4].[dbo].[3s Statusboard Customer]
      ON [Navision4].[dbo].[3S Company A_S$Sales Invoice Header].[Sell-to Customer No_] = [Navision4].[dbo].[3s Statusboard Customer].[No_] 
  WHERE [Document Date] &lt;= '2015-09-25'
  GROUP BY [Sell-to Customer No_], [Document Date]
  </code></pre>
  
  <p>But it's not does what i want do.</p>
  
  <p>Example:</p>
  
  <p>If I have 3 items in [Navision4].[dbo].[3s Statusboard Customer].[No_]</p>
  
  <pre><code>[No_]   
  10
  20
  30
  </code></pre>
  
  <p>But in my table [Navision4].[dbo].[3S Company A_S$Sales Invoice Header] are only records for Customer 10 and 20.</p>
  
  <p>I have no records for customer 30 and this will not be returned. 
  But i want my SQL to return 0 for customer 30 and not hide it.</p>
  
  <p>How can I do that?</p>
  
  <p>Hope i make sense :)</p>