Specifies the database tables or views involved in a SELECT statement.
... FROM table-expression [, …]
table-expression:{ table-spec | table-expression join-type table-spec [ ON condition ] | ( table-expression [, …] ) }
table-spec:{ [ userid.] table-name [ [ AS ] correlation-name ] | select-statement [ AS correlation-name ( column-name [, …] ) ] }
contains-expression:{table-name | view-name } CONTAINS ( column-name [,...], contains-query ) [ [ AS ] score-correlation-name ]
contains-expression Use the CONTAINS clause after a table name to filter the table, and return only those rows matching the full text query specified with contains-query. Every matching row of the table is returned, along with a score column that can be referred to using score-correlation-name, if it is specified. If score-correlation-name is not specified, then the score column can be referred to by the default correlation name, contains.
With the exception of the optional correlation name argument, the CONTAINS clause takes the same arguments as the CONTAINS search condition. There must be a TEXT index on the columns listed in the CONTAINS clause.
See “CONTAINS conditions” and CONTAINS conditions in Chapter 2, “SQL Language Elements,” in Reference: Building Blocks, Tables, and Procedures.
For the full syntax and description of the FROM clause, see FROM clause in Chapter 1, “SQL Statements” of Reference: Statements and Options.
