i need to make up a query, but i need to order my results by the sum of two total sums together.. so the sum of views and the sum of comments gives me a new value, then i sort by that new value, get what i mean?
SELECT SUM(Views) AS Views, SUM(Comments) as Comments, UserID
FROM Photos
GROUP BY UserID
ORDER BY (SUM OF VIEWS AND COMMENTS)
thanks for any help