Запрос на сложение запросов

[ГОСЕАН]

1-й запрос:
SELECT Convert(numeric,COUNT( Expr1 ))
FROM dbo.FV37_5_01 Dbo_fv37_5_01
where (Expr2>:q1 and Expr2<:q2) and Expr3=:g
2-й запрос:
SELECT Convert(numeric,COUNT( Expr1 ))
FROM dbo.FP37_5_01 Dbo_fp37_5_01
where (Expr2>:q1 and Expr2<:q2) and Expr3=:g
Вопрос:
Как сложить эти два значения и вывести в отчет RaveReports.
как лучше сделать?
Если можно, пример....

[D-mon]

select Count(имя любого столбца) CountRec from (
SELECT *
FROM dbo.FV37_5_01 Dbo_fv37_5_01
where (Expr2>:q1 and Expr2<:q2) and Expr3=:g
union
SELECT *
FROM dbo.FP37_5_01 Dbo_fp37_5_01
where (Expr2>:q1 and Expr2<:q2) and Expr3=:g)prom_table
where 1=1

[Serge_Bliznykov]

мой вариант:

select SUM(MY_COUNT) as CountRec 
FROM
( SELECT Convert(numeric,COUNT( Expr1 )) as MY_COUNT
FROM dbo.FV37_5_01 Dbo_fv37_5_01
where (Expr2>:q1 and Expr2<:q2) and Expr3=:g
UNION ALL
SELECT Convert(numeric,COUNT( Expr1 )) as MY_COUNT
FROM dbo.FP37_5_01 Dbo_fp37_5_01
where (Expr2>:q1 and Expr2<:q2) and Expr3=:g)

[ГОСЕАН]

Сообщение от Serge_Bliznykov

мой вариант:

select SUM(MY_COUNT) as CountRec 
FROM
( SELECT Convert(numeric,COUNT( Expr1 )) as MY_COUNT
FROM dbo.FV37_5_01 Dbo_fv37_5_01
where (Expr2>:q1 and Expr2<:q2) and Expr3=:g
UNION ALL
SELECT Convert(numeric,COUNT( Expr1 )) as MY_COUNT
FROM dbo.FP37_5_01 Dbo_fp37_5_01
where (Expr2>:q1 and Expr2<:q2) and Expr3=:g)

говорит Invalid keyword, Token Select, Line Number 3