Hi Guys,
I got this problem with my table as i'm trying to sum up the results of the whole row of records. E.g.

Total
------
4
5
5
5

so the total should be 19. But when i used the following code:

Select SUM(Total) GrandTotal From Table

When i used a MshFlexGrid to view the result
I got this error:

Syntax Error missing operator in query expression 'SUM(Total) GrandTotal From Table
'
Please Help. And can anyone intro me to a site where i can find more help for SQL ?

Thks.