<div>
select players.name,count(gameown<wbr />er.gameid)<wbr /> as games<br />
from players<br />
join gameowner on players.ownerid = gameowner.ownerid<br />
where games &lt;&nbsp;5<br />
group by players.name,games
</div>


select players.name,count(gameowner.gameid) as games
from players
join gameowner on players.ownerid = gameowner.ownerid
where games < 5
group by players.name,games

<div>
Hi Barry,<br />
I wonder whether there might be a problem when the result of the join is a null line, because there is no line matching &quot;join gameowner on players.ownerid = gameowner.ownerid&quot;, (e.g. there is an id on players for which there is no entry on gameowner table). As I see it may result on on a empty/null set. I still want to see those entries. See example output below.<br />
<br />
name | games<br />
john &nbsp; &nbsp; 1<br />
jack &nbsp; &nbsp; &nbsp;0<br />
sam &nbsp; &nbsp; 2
</div>


Hi Barry,
I wonder whether there might be a problem when the result of the join is a null line, because there is no line matching "join gameowner on players.ownerid = gameowner.ownerid", (e.g. there is an id on players for which there is no entry on gameowner table). As I see it may result on on a empty/null set. I still want to see those entries. See example output below.

name | games
john     1
jack      0
sam     2

<div>
Don is correct. &nbsp;Use a left (or outer) join.
</div>


Don is correct.  Use a left (or outer) join.

<div>
<div class="content wysiwyg-content">
Greetings,<br />
I have the following (similar) structure :<br />
<br />
create table players (<br />
&nbsp; ownerid int,<br />
&nbsp; &nbsp;name varchar(10)<br />
)<br />
<br />
create table games (<br />
&nbsp; gameid int,<br />
&nbsp; name varchar(255)<br />
)<br />
<br />
create table gameowner (<br />
&nbsp; ownerid int,<br />
&nbsp; gameid int<br />
)<br />
<br />
I want to make a query where I can list all the owners with less than 'x' games, including those that have none. I am having some problems with the second part. would greatly appreciate your help. <br />
<br />
r
</div>
</div>


Greetings,
I have the following (similar) structure :

create table players (
  ownerid int,
   name varchar(10)
)

create table games (
  gameid int,
  name varchar(255)
)

create table gameowner (
  ownerid int,
  gameid int
)

I want to make a query where I can list all the owners with less than 'x' games, including those that have none. I am having some problems with the second part. would greatly appreciate your help. 

r

How to retrieve query results when count() = 0 ?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.