Home Forums Article Discussions Article Discussions by Author Discuss content posted by Richard Rozema Combining union and union all RE: Combining union and union all
archie flockhart
SSCrazy
Points: 2339
More actions
March 8, 2012 at 1:44 am
#1456394
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