FROM clause - RisingWave

The FROM clause specifies the source of the data on which the query should operate. Logically, the FROM clause is where the query starts execution. It can contain a single table, a combination of multiple joined tables, or another SELECT query inside a subquery node. The FROM clause derives a table from one or more tables in a comma-separated table reference list. Here is the basic syntax of the FROM clause: A table_reference can be a table name, a derived table such as a subquery, a JOIN construct, or complex combinations. If multiple sources are specified, the result is all the sources’ Cartesian product (i.e., cross join). The result of the FROM list is an intermediate virtual table that can then be subject to transformations by the WHERE, GROUP BY, and HAVING clauses and is finally the result of the overall table expression. A joined table is a table derived from two other (real or derived) tables according to the rules of the particular join type. Inner, outer, and cross-joins are

saved by

• Hieu Tran