Re: SUM problem.
Quote
Peter Brawley Wrote:
-------------------------------------------------------
> Patric,
>
> > I hope this is what you where looking for.
>
> Alas not. To use it I'd have to derive and type
> all CREATE TABLE and INSERT statemtnts required to
> replicate your problem, so it's possible to test
> the solution I offer (for a paying client one
> would do the typing). Once again: we need the
> results of SHOW CREATE TABLE, plus actual INSERT
> statements to replicate the sample data.
>
> PB
Yes, I was kinda hoping he'd do the select for a single tourney with all the relevant fields and data (say the top 10 to 20 lines) and he could then select that data to an intermediate table.
We could then show him how to pair it down from there to get his data.
So Patrick if you think of my bowling example as the "final output" then it shows you how to summarize it as necessary.
Obviously you don't want to use extra tables all the time, so the idea is that once you understand how to pair the data down, you work the logic into the original SELECT queries and do it in first step.
>
Thanks, Jay