Duplicate rows are removed from the result set by default

ASE evaluates a statement containing union operators from left to right

Order by and group by clauses are not allowed in a union query

The into clause can be used only in the first query