meltingpot
Technical User
Hi chaps
Im trying to solve a simple maths problem
example
10(Quals)+6(Crew)-4(statuscode)=12(result)
Using the following SQL Query
SELECT (Courselist.quals+Courselist.crew)-Applications.StatusCode
FROM Courselist INNER JOIN Applications ON Courselist.CourseID = Applications.CourseID
WHERE Courselist.CourseID=ID AND Applications.StatusCode='Accepted'
Note: Courselist.CourseID is posted from Request.QueryString on an ASP web page.
Im having no luck, can anybody help
Im trying to solve a simple maths problem
example
10(Quals)+6(Crew)-4(statuscode)=12(result)
Using the following SQL Query
SELECT (Courselist.quals+Courselist.crew)-Applications.StatusCode
FROM Courselist INNER JOIN Applications ON Courselist.CourseID = Applications.CourseID
WHERE Courselist.CourseID=ID AND Applications.StatusCode='Accepted'
Note: Courselist.CourseID is posted from Request.QueryString on an ASP web page.
Im having no luck, can anybody help