How can I return a column that says "No" for values missing from the result?
<p>Sorry for the poor phrasing in the title; I can't figure out how to explain my question succinctly.</p>

<p>I have a list of <code>fruit</code> (<code>apple</code>, <code>banana</code>, <code>pear</code>) and want to create a table which looks like:</p>

<pre><code>fruit   eaten

apple   yes
banana  yes
pear    no
</code></pre>

<p>from a table that looks like</p>

<pre><code>fruit   quantity

apple   120
banana  30
</code></pre>

<p>(Note that the original table does not include pears). So far I've figured out how to get to:</p>

<pre><code>fruit   eaten

apple   yes
banana  yes
</code></pre>

<p>by the query:</p>

<pre><code>select
fruit,
case when quantity &gt; 0 then "yes" else no end as eaten
from original_table
</code></pre>

<p>But I can't figure out how to get those pesky pears to be included.</p>