title: PostgreSQL - how to have the 0 values using a WHERE?
body: <p>i am currently working on PostgreSQL having 2 data tables : item and order.</p>
  <p>I want to display the number of order for each item in a period of time, but i would like to keep the name displayed if it's 0.</p>
  <p>i'm actually doing:</p>
  <pre><code>SELECT Item.name, count(Order.id) from Item
  INNER JOIN Order ON Item.id = Order.it_id
  WHERE Order.date &gt; '01/08/2021'
  </code></pre>
  <p>The problem is that my results are:</p>
  <pre><code>Chocolate | 1
  Cake | 2
  Muffin | 3
  </code></pre>
  <p>And i would like to have:</p>
  <pre><code>Chocolate | 1
  Cake | 2
  Muffin | 3
  Pancake | 0
  Donut | 0
  </code></pre>
  <p>I have used a RIGHT JOIN that is working without my WHERE condition but i need to filter with the date for my results values.</p>
  <p>Maybe i'm not in the good way to do it.
  I don't know if it is possible or if there an other way to do it.</p>
  <p>thank you in advance.</p>