Can anyone help?

[Anon]

Is it possible to calculate the sum of a calculated column in SQL? For instance, in the sql statement below:

SELECT numdays, totalrevenue, (numdays * totalrevenue) AS coursecost
FROM courses

I am trying to get the SUM of the calculated column, coursecost, but cannot without getting errors. Does anyone know of anyway of doing this. Any assistance would be greatly appreciated.

Thanks,
CE

[[deleted]]

What is the error you are getting, and how are you trying to get the data back out?

[Anon]

The current error I am getting is "Invalid column name 'coursecost'", where coursecost is the calculated column from my sql.

The sql I am using to retrieve the data is given below:

SELECT courses.numdays,calendarevents.totalrevenue, courses.numdays * calendarevents.totalrevenue AS coursecost
FROM
calendarevents INNER JOIN courses ON calendarevents.courseid = courses.courseid INNER JOIN coursecat ON courses.coursecatid = coursecat.coursecatid
COMPUTE SUM(numdays), SUM(totalrevenue), SUM(coursecost)

It could very likely be a syntax issue with the sql statement above. Can you see anything wrong it? Let me know what you think.

Thanks,
CE

[bastien]

SELECT courses.numdays,calendarevents.totalrevenue, sum(courses.numdays * calendarevents.totalrevenue) AS coursecost
FROM....

hth

Bastien

[Anon]

Just tried out your suggestion and it worked! I really do appreciate the help. Take care!

CE