Re: Count Query question

[Chris W]

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
>
>
>
>