SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table table1
(
    RowID int,
    Row varchar(max),
    z varchar(max)
);

create table table2
(
    RowID int,
    Row varchar(max),
    z varchar(max)
);
insert into table1 values
(1, '031T000000100', '0000001'),
(1, '031T000000200', '0000002');

insert into table2 values
(3, '032T000000100', '0000001'),
(3, '032T000000200', '0000002');
4 rows affected

select RowID, Row, z
FROM table1 
UNION
SELECT *
FROM table2
ORDER BY z, RowID


RowID
Row
z


1
031T000000100
0000001

3
032T000000100
0000001

1
031T000000200
0000002

3
032T000000200
0000002

RowID	Row	z
1	031T000000100	0000001
3	032T000000100	0000001
1	031T000000200	0000002
3	032T000000200	0000002