Hello folks, I'm new here, I'm actually a Java guy who is doubling as a database programmer for now...

So...I have a table called Funds and columns are Q1, Q2, Q3, Q4, and funds_id (this is psuedo of course). So I need to get the total of all these, like I need to do this:

select (Q1 + Q2 + Q3 + Q4) as yearly_total
where funds_id = 'XXX'

something like that.

So how would I do that? Would I want to build a view? Thanks.

Edit: what I meant was, how would I use the SUM function, or could I just do it using the + symbol?