List:General Discussion« Previous MessageNext Message »
From:Chris W Date:May 12 2010 2:05pm
Subject:Re: Count Query question
View as plain text  
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
>
>
>
>   
Thread
Count Query questionKeith Clark12 May
  • Re: Count Query questionChris W12 May
    • Re: Count Query questionKeith Clark12 May
      • Re: Count Query questionKeith Clark12 May
        • Re: Count Query questionBob Cole13 May
          • Re: Count Query questionKeith Clark13 May
            • Re: Count Query questionBob Cole13 May
              • Re: Count Query questionKeith Clark13 May
                • RE: Count Query questionwebmaster13 May