Sum a few Fields...

[davebhoy]

Hi there

I hope this a simple question!

I've just upgraded to SQL from Access and I'm using the designer to create a select query in enterprise manager.

I have about 5 fileds with alias's that I want to show as a total field. How do I create an expression in the column field to add the five fields to give one total?

In Access I just created a simple formula field1+field2 etc

Thanks in advance

Dave

 

[cjard]

In SQL:

SELECT a, b, a+b as total FROM table