SQL Server 2017

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

create table t1(id int, name varchar(10))
insert into t1 values(1,'Charlie'),(2,'Bob'),(3,'Alice')
3 rows affected

select * from t1 a, t1 b
where a.id != b.id


id
name
id
name


2
Bob
1
Charlie

3
Alice
1
Charlie

1
Charlie
2
Bob

3
Alice
2
Bob

1
Charlie
3
Alice

2
Bob
3
Alice

id	name	id	name
2	Bob	1	Charlie
3	Alice	1	Charlie
1	Charlie	2	Bob
3	Alice	2	Bob
1	Charlie	3	Alice
2	Bob	3	Alice