MySQL join, even when 0 <p>Im doing the follwing, to create an user report</p> <pre><code>SELECT b.username, b.name, b.permissiontoedit, a.total, a.user FROM (SELECT user, Count( * ) AS total FROM products GROUP BY user)a JOIN user b ON a.user = b.username </code></pre> <p>This should give a table with the username, full name, permision (1/0) and the total of entries.</p> <p>Sadly, the query does only list users, which made more 1 or more entries in the table <code>products</code>. But i want all users, and if the have not made any entries in <code>products</code> it should display 0 or nothing. </p> <p>where do i made a mistake? </p>