Quadcap Software

Quadcap Embeddable Database

Quadcap Software

FROM

The FROM clause is used to specify the source of data for the query, and may be either a simple expression which refers to a table or view, or a join expression, joining two tables.

If multiple tables are specified in the FROM clause, they are joined implicitly, using a cross join, or Cartesian product. Conceptually, this table source consists of all possible combinations of rows from each of the two joined tables.

Syntax

selectFrom
  :  (  "from" tableReference ( COMMA tableReference )* 
    |  
    ) 
  ;