Certain rules and restrictions apply to SELECT statements connected by set operators that may not apply elsewhere. Number of Expressions in SELECT Statements WITH Clause and Set Operators GROUP BY and ORDER BY Clauses Table Name in SELECT Statements Data Type Compatibility Queries Connected by Set Operators Related Information