SQL: The SUM of Multiple Columns

[VernMan]

Can someone please tell me how to SUM mulitple columns using SQL.

I know that this will sum 2 columns:

SELECT
SUM(billing.space_cost) + SUM(billing.pub_box)
FROM billing

and thought that this would do more, but it does not seem to work:

SELECT
(SUM(billing.space_cost) + SUM(billing.pub_box) + SUM(billing.messenger))
FROM billing

Anyone know this one?

[Newsgroup_User]

This should work fine. The syntax you provide will certainly SUM these 3
columns ok, providing they are numeric.

Pat.

"VernMan" <webforumsuser@macromedia.com> wrote in message
news:ff5cc5$n8h$1@forums.macromedia.com...
> Can someone please tell me how to SUM mulitple columns using SQL.
>
> I know that this will sum 2 columns:
>
> SELECT
> SUM(billing.space_cost) + SUM(billing.pub_box)
> FROM billing
>
> and thought that this would do more, but it does not seem to work:
>
> SELECT
> (SUM(billing.space_cost) + SUM(billing.pub_box) + SUM(billing.messenger))
> FROM billing
>
> Anyone know this one?
>