The FROM Clause

The FROM clause specifies the table to query. When using ActiveSpaces, a FROM clause is required in a SELECT statement. The FROM clause syntax supported by ActiveSpaces is the following:

FROM <table name> [ [AS] <correlation name> ]

A correlation name is an identifier that is associated with the specified table and can be used in place of the table name anywhere within the SELECT statement. The following code snippet serves as an example:

SELECT t.* FROM mytable AS t WHERE t.col1 = 100