MySQL 8.0

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

select version();


version()


8.0.36


CREATE TABLE Products (
    id	int, 
    Product varchar(25)
);

INSERT INTO Products VALUES
(1,	'Product No.1'),
(2,	'Product No.2'),
(3,	'Product No.3');

select * from Products;

Records: 3  Duplicates: 0  Warnings: 0




id
Product


1
Product No.1

2
Product No.2

3
Product No.3


CREATE TABLE Grades (
    id	int, 
    Grade varchar(25)
);

INSERT INTO Grades VALUES
(1,	'grade 1'),
(2,	'grade 2'),
(3,	'grade 3');

select * from Grades;

Records: 3  Duplicates: 0  Warnings: 0




id
Grade


1
grade 1

2
grade 2

3
grade 3


  Select *
   From  Products
      CROSS JOIN 
         Grades;


id
Product
id
Grade


3
Product No.3
1
grade 1

2
Product No.2
1
grade 1

1
Product No.1
1
grade 1

3
Product No.3
2
grade 2

2
Product No.2
2
grade 2

1
Product No.1
2
grade 2

3
Product No.3
3
grade 3

2
Product No.2
3
grade 3

1
Product No.1
3
grade 3


  Select P.Product, G.Grade
   From  Products P
      CROSS JOIN 
         Grades G
  Order by P.Product, G.Grade;


Product
Grade


Product No.1
grade 1

Product No.1
grade 2

Product No.1
grade 3

Product No.2
grade 1

Product No.2
grade 2

Product No.2
grade 3

Product No.3
grade 1

Product No.3
grade 2

Product No.3
grade 3

id	Product	id	Grade
3	Product No.3	1	grade 1
2	Product No.2	1	grade 1
1	Product No.1	1	grade 1
3	Product No.3	2	grade 2
2	Product No.2	2	grade 2
1	Product No.1	2	grade 2
3	Product No.3	3	grade 3
2	Product No.2	3	grade 3
1	Product No.1	3	grade 3