dodawanie wartosci po union

Witam
zapytanie
select sum(u1.S) from UP1 as u1
union
select sum(u2.S) from UP2 as u2
daje wynik
12
37
i moje pytanie czy da sie zsumowac te 2 wyniki aby wyszlo 49??

select sum(kol) from
(
select sum(u1.S) kol from UP1 as u1
union
select sum(u2.S) kol from UP2 as u2
)

johny_bravo napisał(a)

select sum(kol) from
(
select sum(u1.S) kol from UP1 as u1
union
select sum(u2.S) kol from UP2 as u2
)

niestety to zapytanie mi nie dziala dostaje
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ')'.
cos takiego

SELECT sum(kol) FROM
(
SELECT sum(u1.S) kol FROM UP1 AS u1
union
SELECT sum(u2.S) kol FROM UP2 AS u2
) AS x