From: Chris W
Date: May 12 2010 2:05pm
Subject: Re: Count Query question
List-Archive: http://lists.mysql.com/mysql/221557
Message-Id: <4BEAB5AC.2090000@cox.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

With out the table definitions, I'm not sure how anyone could help.  Can 
you send the output of "show create table" for each of the tables 
involved in this query?

Chris W

Keith Clark wrote:
> I'm trying to produce a report that will tell me how many products were
> available with a Quantity>0 before a certain date, and have that ordered
> by date.
>
> Table:
>
> Date
> Quantity
>
> Result desired
>
> Date	Quantity Available
> May 1	5000
> May 2	5050
> May 3	5075
>
> Thanks,
>
> Keith
>
>
>
>