MySQL 8.0

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

select version();


version()


8.0.27


CREATE TABLE tbl_hashs(
   h_id INTEGER  NOT NULL PRIMARY KEY 
  ,r_id INTEGER  NOT NULL
  ,hash VARCHAR(2) NOT NULL
);
INSERT INTO tbl_hashs(h_id,r_id,hash) VALUES (1,122,'xx');
INSERT INTO tbl_hashs(h_id,r_id,hash) VALUES (2,123,'xx');
SELECt * FROM tbl_hashs;


h_id
r_id
hash


1
122
xx

2
123
xx


SELECT
   t1.h_id,
   t2.r_id,
   t2.hash
FROM tbl_hashs t1
CROSS JOIN tbl_hashs t2
ORDER BY t1.h_id


h_id
r_id
hash


1
122
xx

1
123
xx

2
122
xx

2
123
xx