I have probably a pretty simple problem that i do not understand why i does not work.
My database questions is:
SELECT COMPAN, SUM(AMOUNT) AS SALES
WHERE (ACCOUNT = 3010)
ORDER BY COMPAN
If I remove the WHERE then everything works but I dont get in that case what I want. Why cant I do like this? Secondly in that case how shall I do it then?
Thanx in advance
View Complete Post