By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table teams (id int identity not null primary key, col1 varchar(10) not null);
insert into teams (col1) values ('X1'),('X2'),('X3'),('X4'),('X5');
-- If id didn't exist
Select t1.Col1 team1, t2.Col1 team2
from Teams t1
cross join Teams t2
where t1.Col1 < t2.Col1
order by t1.Col1, t2.Col1;
Select t1.Col1 team1, t2.Col1 team2
from Teams t1
cross join Teams t2
where t1.Id < t2.Id
order by t1.Id, t2.Id;
| team1 | team2 |
|---|---|
| X1 | X2 |
| X1 | X3 |
| X1 | X4 |
| X1 | X5 |
| X2 | X3 |
| X2 | X4 |
| X2 | X5 |
| X3 | X4 |
| X3 | X5 |
| X4 | X5 |
| team1 | team2 |
|---|---|
| X1 | X2 |
| X1 | X3 |
| X1 | X4 |
| X1 | X5 |
| X2 | X3 |
| X2 | X4 |
| X2 | X5 |
| X3 | X4 |
| X3 | X5 |
| X4 | X5 |