sql counting references in other table
<p>If a book as 0 sales, it gets not listed by this query.</p>

<p>But I really need it there :)</p>

<p>How can this be fixed ?</p>

<pre><code>SELECT 
    description, author, count(sales.*) as "amount of sales"
FROM 
    books, sales 
WHERE 
    books.id = sales.book_id 
GROUP BY 
    books.id;
</code></pre>