Help with Query 1

[alexanderthegreat]

SELECT
( SELECT SUM(aes.S2C_TTL) FROM dbo.AES_ES_2 AS aes )
+ ( SELECT SUM(aes.S2C_TTL) FROM dbo.AES_HS_2 AS aes )
AS TotalArtsSpending / (Select ENROLL_TT from AES_CONTACT_SCHOOL)AS PerPupilSpending

Im trying to take the sum of two fields and divide by another while assigning a new name to each calculaton

 

[Golom]

SELECT 

    ( SELECT SUM(S2C_TTL) FROM dbo.AES_ES_2) 
  + ( SELECT SUM(S2C_TTL) FROM dbo.AES_HS_2) AS TotalArtsSpending,

    (( SELECT SUM(S2C_TTL) FROM dbo.AES_ES_2) 
  +  ( SELECT SUM(S2C_TTL) FROM dbo.AES_HS_2))
  / (Select ENROLL_TT from AES_CONTACT_SCHOOL)AS PerPupilSpending

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[alexanderthegreat]

SELECT

( SELECT SUM(S2C_TTL) FROM dbo.AES_ES_2)
+ ( SELECT SUM(S2C_TTL) FROM dbo.AES_HS_2) AS TotalArtsSpending,

(( SELECT SUM(S2C_TTL) FROM dbo.AES_ES_2)
+ ( SELECT SUM(S2C_TTL) FROM dbo.AES_HS_2))
/ (Select ENROLL_TTL from AES_CONTACT_SCHOOL)AS PerPupilSpending


Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Warning: Null value is eliminated by an aggregate or other SET operation.

We need the sum of ENROLL_TTL

 

[Golom]

This

Select ENROLL_TTL from AES_CONTACT_SCHOOL

is the problem

Should it be

Select [COLOR=red]SUM([/color]ENROLL_TTL[COLOR=red])[/color] from AES_CONTACT_SCHOOL

?

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]