Postgres 16

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

select * 
from (values ('a'),('b'),('c'))AS a(letters)
join (values (1),(2),(3))AS b(numbers) on true


letters
numbers


a
1

a
2

a
3

b
1

b
2

b
3

c
1

c
2

c
3



SELECT 9


select * 
from (values ('a'),('b'),('c'))AS a(letters)
cross join 
     (values (1),(2),(3))AS b(numbers)


letters
numbers


a
1

a
2

a
3

b
1

b
2

b
3

c
1

c
2

c
3



SELECT 9


select * 
from (values ('a'),('b'),('c'))AS a(letters)
,    (values (1),(2),(3))AS b(numbers)


letters
numbers


a
1

a
2

a
3

b
1

b
2

b
3

c
1

c
2

c
3



SELECT 9