On 23-Jul-02 Prather, Wanda wrote:
> This goes top down instead of side by side ...
> but it's quick and easy!
>
>  select stgpool_name, sum(physical_mb)/1024 as physical_GB
>   from occupancy                -
>  group by stgpool_name order by stgpool_name

Hmm....I think it's "not quick and dirty"...;-) :

ANR2963W This SQL query may produce a very large result table, or may
require a significant amount of time to compute.

And yes, it take some time, but the result is ok.

Cheers,
Henk ten Have.