Hi,
2006/6/21, Helen M Hudson <[EMAIL PROTECTED]>:
Yes, I can see how this would work for just the one order and hardcoding the
100... but I cannot assume only to sum distinct values and my table has
other order_refs in it with the same multiple rows of over multiple days, so
I need a more gene
Yes, I can see how this would work for just the one order and hardcoding the
100... but I cannot assume only to sum distinct values and my table has
other order_refs in it with the same multiple rows of over multiple days, so
I need a more generic select that will list this nice summary for all
Helen M Hudson schrieb:
Hi all
I'm gradually learning how much simpler it is to do things with joins. I can
tell that I haven't seen the light yet... but I'm expecting fireworks pretty
soon when it all falls into place brain-wise and I can wallow in the joy of
smaller more efficient sql!
I'
Helen M Hudson ha scritto:
> So, if my table structure was:
> id | date | order_ref | amount
> 1 | 1/1/01 | 100 | 1000 << these 2 are the rows
> 2 | 1/1/01 | 100 | 200 << i want to exclude
> 3 | 2/1/01 | 100 | 1000
> 4 | 2/1/01 | 100 | 200
> 5 | 2/1/01 | 100 |
