The data type, title, and format clauses contained in the first SELECT statement in the intersection determine the data type, title, and format information that appear in the final result.
Attributes for all other SELECT statements in the query are ignored.