CareerCup

SELECT
Team1.TEAM_NAME AS Team1,
Team2.TEAM_NAME AS Team2
FROM TEAM Team1
INNER JOIN TEAM Team2 ON Team1.TEAM_ID > Team2.TEAM_ID

This comment has been deleted.

SELECT
Team1.TEAM_NAME AS Team1,
Team2.TEAM_NAME AS Team2
FROM TEAM Team1, TEAM Team2
WHERE Team1.TEAM_ID > Team2.TEAM_ID

The query
SELECT
Team1.TEAM_NAME AS Team1,
Team2.TEAM_NAME AS Team2
FROM TEAM Team1, TEAM Team2
WHERE Team1.TEAM_ID > Team2.TEAM_ID
is absolutely correct, the reverse condition (Team1.TEAM_ID < Team2.TEAM_ID) would also result in the right permutation & combination

--Create Teams Table
CREATE table teams
(
id int,
name varchar(20)
)

insert into teams
(
id,
name
)
VALUES
(
1, -- id - int
'France' -- name - varchar
)

-- Insert sample data

insert into teams
(
id,
name
)
VALUES
(
2, -- id - int
'Germany' -- name - varchar
)

insert into teams
(
id,
name
)
VALUES
(
3, -- id - int
'Spain' -- name - varchar
)

--Generate fixtures between team

SELECT * from teams t CROSS join teams t2
WHERE t.id > t2.id

SELECT * from teams t CROSS join teams t2
WHERE t.id > t2.id