MySQL 8.0

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

CREATE TABLE table1 (
    id int,
    foo text
);
CREATE TABLE table2 (
    id int,
    bar text
);
INSERT INTO table1 VALUES
(1, 'abc'),
(2, 'bcd');

Records: 2  Duplicates: 0  Warnings: 0


INSERT INTO table2 VALUES
(1, 'abc'),
(2, 'BCDE'),
(3, 'bcd'),
(4, 'efg');

Records: 4  Duplicates: 0  Warnings: 0


SELECT * FROM table1, table2


id
foo
id
bar


2
bcd
1
abc

1
abc
1
abc

2
bcd
2
BCDE

1
abc
2
BCDE

2
bcd
3
bcd

1
abc
3
bcd

2
bcd
4
efg

1
abc
4
efg


SELECT * FROM table1 CROSS JOIN table2


id
foo
id
bar


2
bcd
1
abc

1
abc
1
abc

2
bcd
2
BCDE

1
abc
2
BCDE

2
bcd
3
bcd

1
abc
3
bcd

2
bcd
4
efg

1
abc
4
efg


SELECT * FROM table1, table2 WHERE table1.id = table2.id


id
foo
id
bar


1
abc
1
abc

2
bcd
2
BCDE


SELECT * FROM table1 CROSS JOIN table2 ON (table1.id = table2.id)


id
foo
id
bar


1
abc
1
abc

2
bcd
2
BCDE


SELECT * FROM table1 INNER JOIN table2 ON (table1.id = table2.id)


id
foo
id
bar


1
abc
1
abc

2
bcd
2
BCDE

id	foo	id	bar
2	bcd	1	abc
1	abc	1	abc
2	bcd	2	BCDE
1	abc	2	BCDE
2	bcd	3	bcd
1	abc	3	bcd
2	bcd	4	efg
1	abc	4	efg