Both. In some rows, t2.number
is number
and in others t3.number
is number
.
The result of the union all
in a single result set. The result set doesn’t know the origin of the values in any particular column (although you could include another column with this information).
3
solved Selecting the right column