Postgres 9.6

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

select version();

version

PostgreSQL 9.6.24 on x86_64-pc-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit

SELECT 1

CREATE TABLE table1 (id int);
CREATE TABLE table2 (id int);

CREATE TABLE

INSERT INTO table1
(id)
VALUES
(1),
(1),
(3);

INSERT INTO table2
(id)
VALUES
(1),
(1),
(2);

INSERT 0 3

SELECT * FROM table1;

id

1

1

3

SELECT 3

SELECT * FROM table2;

id

1

1

2

SELECT 3

SELECT *
FROM table1
   INNER JOIN table2
      ON table1.id = table2.id;

id
id

1
1

1
1

1
1

1
1

SELECT 4

SELECT DISTINCT *
FROM table1
   INNER JOIN table2
      ON table1.id = table2.id;

id
id

1
1

SELECT 1

select * 
from table1
   cross join table2; 

id
id

1
1

1
1

1
2

1
1

1
1

1
2

3
1

3
1

3
2

SELECT 9

SELECT * 
FROM table1
   LEFT JOIN table2 
       ON table1.id = table2.id;

id
id

1
1

1
1

1
1

1
1

3
null

SELECT 5

SELECT DISTINCT * 
FROM table1
   LEFT JOIN table2 
       ON table1.id = table2.id;

id
id

3
null

1
1

SELECT 2

id	id
1	1
1	1
1	1
1	1
3	null

id	id
3	null
1	1