select sum(*) as * - if possible

[sean982]

I am really new to this sql stuff so please be kind.

I am wondering if you can sum up all numeric fields using a query like select sum(*) as * from ....

The idea is that it accomplishes the following
select sum(column1) as column1, sum(column2) as column2, ... from

I see from other posts that I might have to do it the long way, plus it might make it easier to read for the poor fool that might have to work through my code in the future.

All thoughts would be appreciated.

[Kid Charming]

Nope, you have to do it the long way. Which is actually going to be kinder to that poor future fool, since they'll be able to see exactly what columns you're working with.

[sean982]

I figured as much.

Thanks! This is definitely a learning process.