• Explanation is wrong: you can get multiple rows even if you use UNION in the query.

    You can try it using the tables in the question:

    select col from #t2

    union

    select col from #t3

    union all

    select col from #t1

    Results:

    col

    2

    3

    1

    1