On Nov 16, 2007 4:26 AM, Stefan Schwarzer <stefan.schwarzer@grid.unep.ch> wrote:
>
> Hi there,
>
> I run an aggregation on national statistics to retrieve regional values (for
> Africa, Europe, ...). Now, I want to have a global aggregation as well. The
> easiest thing for my PHP/HTML procedure would be to have the global row make
> appear within the regional result. So it would be something like
>
> name | y_2001 | y_2002 .....
> --------------------------------------------------------
> Africa | 2323 | 342323
> Europe | ....
> .....
> Global | 849309 | .....
> Is there a way to substitute this with a "static" value, such as "Global"?
> So, that the query still results in three columns?
Sure, just include it as 'Global'
Note the single, not double, quotes.