Small. Fast. Reliable.
Choose any three.

table-or-subquery

schema-name . table-name AS table-alias INDEXED BY index-name NOT INDEXED table-function-name ( expr ) , AS table-alias ( select-stmt ) ( table-or-subquery ) , join-clause

Used by:   join-clause   select-core   select-stmt   update-stmt   update-stmt-limited

References:   expr   join-clause   select-stmt

See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html