sum two select statements in sql

Question

I'm looking to produce the sum of these two select statements:

select sum(amount) as hr from friday.dbo.FMDR_Friday_CSV where [Account #] like 4010

select sum(amount) as hr from friday.dbo.FMDR_Friday_CSV where [Account #] like 4060

I've tried putting a union between them, which only serves to produce the two results in the same results window.

Thanks for any help, I'm an absolute beginner.

Answer 1

In case you want to use multiple selects (maybe if other tables are involved)

select ((select sum(hours) from foo1) +
        (select sum(hours) from foo2)) as totalHours