> > BTW, I don't believe the self-join approach proposed
> > earlier will work, because joining on "scanid" will
> > create a cartesian type join where the region values
> > will be duplicated (multiplicated!).
>
> Not if you're talking about my query, they won't. I use that query form
> in many projects to create roll-ups; it's the "best" SQL92 approach to
> the "pivot table" problem. However, it will not work in 7.0.3.
I think he might be talking about mine. The region values will not be
duplicated, the WHERE clause prevents it.
I kind of prefer my own query aesthetically, is it as efficient internally?
- James