>SELECT
SUM(Cte1.Amount) AS Cte1Amount,
>
SUM(Cte2.Amount) AS Cte2Amount
>FROM (SELECT SUM(Amount) AS Amount FROM Cte1) Cte1,
> (SELECT SUM(Amount) AS Amount FROM Cte2) Cte2
You do not need the bolded SUMs in the last select, or am I missing something?
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges