The Syntax of the SELECT Statement

The SELECT syntax supported has the following format:

SELECT <select list> <FROM clause> [<WHERE clause>] [<GROUP BY clause>] [<ORDER BY clause>] [<LIMIT clause>]

Notice that <FROM clause> is not optional. Use of a SELECT statement with ActiveSpaces is always intended to query data in the data grid and the table to query must always be specified by including <FROM clause>.