Subject Re: [IBO] aggregate fields? Persistant fields?
Author Paul Vinkenoog
Hi NN ;-)

> I will have to look into this. SQL alias? Is there an example of
> this somewhere?

I mean something like this:

select street, count( shop ) as num_shops
from shops
group by street

The output columns will be called STREET and NUM_SHOPS. Without the
alias num_shops the second column would have been called COUNT.

I think the right name is "column alias", not "SQL alias" like I said
in my previous post.


Greetings,
Paul Vinkenoog