At 7:40 PM -0400 9/18/01, Raymond Prisament wrote:
>In the course of using MySQL the following issue has come up a few times; I
>am unaware of the solution for it, but I am sure one exists, since it seems
>fairly elementary. It has to do with the COUNT(*) and GROUP BY functions.
>
>Let's say I ha
D]
Subject: Count(*) with zero rows
In the course of using MySQL the following issue has come up a few times; I
am unaware of the solution for it, but I am sure one exists, since it seems
fairly elementary. It has to do with the COUNT(*) and GROUP BY functions.
Let's say I have clients, and cl
In the course of using MySQL the following issue has come up a few times; I
am unaware of the solution for it, but I am sure one exists, since it seems
fairly elementary. It has to do with the COUNT(*) and GROUP BY functions.
Let's say I have clients, and clients buy items.
table clients:
-