queryExpression (UNION|INTERSECT|EXCEPT) [ALL] queryExpression [ORDER BY...]
You can use the SQL
EXCEPT set operations in Teiid to combine the results of query expressions.
The output columns will be named by the output columns of the first set operation branch.
SELECTmust have the same number of output columns and compatible data types for each relative column. Data type conversion is performed if data types are inconsistent and implicit conversions exist.
EXCEPTis specified without
all, then the output columns must be comparable types.
You cannot use the SQL