|< < 17 > >|

Set operations

union all

union all preserves duplicates.
select * from a union all select * from b

X
1
1
2
2
2
3
3
3
3
3
4
5

|< < 17 > >|