SQL Server 2019 (Linux)

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

-- Create the Product table
CREATE TABLE Product (
    ProductId INT PRIMARY KEY,
    ProductName VARCHAR(50)
);

-- Insert data into the Product table
INSERT INTO Product (ProductId, ProductName)
VALUES
    (1, 'T-shirt'),
    (2, 'Jeans'),
    (3, 'Sneakers');

-- Create the Color table
CREATE TABLE Color (
    ColorId INT PRIMARY KEY,
    ColorName VARCHAR(50)
);

-- Insert data into the Color table
INSERT INTO Color (ColorId, ColorName)
VALUES
    (101, 'Red'),
    (102, 'Blue'),
    (103, 'Green');
6 rows affected

SELECT *
FROM Product


ProductId
ProductName


1
T-shirt

2
Jeans

3
Sneakers


SELECT *
FROM Color


ColorId
ColorName


101
Red

102
Blue

103
Green


SELECT *
FROM Product
CROSS JOIN Color
ORDER BY ProductId
	,ColorId;


ProductId
ProductName
ColorId
ColorName


1
T-shirt
101
Red

1
T-shirt
102
Blue

1
T-shirt
103
Green

2
Jeans
101
Red

2
Jeans
102
Blue

2
Jeans
103
Green

3
Sneakers
101
Red

3
Sneakers
102
Blue

3
Sneakers
103
Green


SELECT *
FROM Product
	,Color
ORDER BY ProductId
	,ColorId;


ProductId
ProductName
ColorId
ColorName


1
T-shirt
101
Red

1
T-shirt
102
Blue

1
T-shirt
103
Green

2
Jeans
101
Red

2
Jeans
102
Blue

2
Jeans
103
Green

3
Sneakers
101
Red

3
Sneakers
102
Blue

3
Sneakers
103
Green

ProductId	ProductName	ColorId	ColorName
1	T-shirt	101	Red
1	T-shirt	102	Blue
1	T-shirt	103	Green
2	Jeans	101	Red
2	Jeans	102	Blue
2	Jeans	103	Green
3	Sneakers	101	Red
3	Sneakers	102	Blue
3	Sneakers	103	Green