>>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?
No, you don't need them, copy and paste problem :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.