You can specify the subqueries and sets of values by using INTERSECT, UNION, EXCEPT, INTERSECT ALL, UNION ALL, and EXCEPT ALL composition operators.
A FULLSELECT statement can be nested as a subquery in other SQL statements.
A VALUES clause specifies rows of values that can be simple or complex expressions. You can specify one or more values rows in a VALUES clause. Each VALUES row consists of values for each column of a row in the results table for the FULLSELECT statement. Depending on the composition operator that is selected, the values might or might not be included in the results table.
You cannot use an ORDER BY clause on a SELECT statement within the FULLSELECT statement. The ORDER BY clause applies to the final result set from the FULLSELECT statement. You can sort on either a single column or multiple columns.
See your database vendor documentation for information about the syntax of FULLSELECT statements. Different database vendors use different syntax.