MySQL 8.0

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

create table table1 (id int auto_increment primary key, name varchar(10))
create table table2 (table1_id int , value varchar(10))
insert into table1 (name) values ('date'), ('name' ), ('city')
insert into table2 values
(1, '2018-12-30'),
(1, '2018-12-20'),
(1, '2018-12-25'),
(2, 'nick'),
(2, 'fred'),
(2, 'jim'),
(3, 'london'),
(3, 'sydney'),
(3, 'new york')
SELECT *
FROM table1 
JOIN table2 ON table2.table1_id = table1.id
ORDER BY RAND(), table2.value


id
name
table1_id
value


3
city
3
new york

3
city
3
london

1
date
1
2018-12-20

2
name
2
nick

1
date
1
2018-12-30

1
date
1
2018-12-25

2
name
2
fred

3
city
3
sydney

2
name
2
jim


SELECT *
FROM (SELECT * FROM table1 ORDER BY RAND()) t1
JOIN table2 ON table2.table1_id = t1.id
ORDER BY t1.name, table2.value


id
name
table1_id
value


3
city
3
london

3
city
3
new york

3
city
3
sydney

1
date
1
2018-12-20

1
date
1
2018-12-25

1
date
1
2018-12-30

2
name
2
fred

2
name
2
jim

2
name
2
nick

id	name	table1_id	value
3	city	3	new york
3	city	3	london
1	date	1	2018-12-20
2	name	2	nick
1	date	1	2018-12-30
1	date	1	2018-12-25
2	name	2	fred
3	city	3	sydney
2	name	2	jim