MySQL 8.0

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

CREATE TABLE t1 (i INT, j INT);
CREATE TABLE t2 (k INT, j INT);
INSERT INTO t1 VALUES(1, 1);
INSERT INTO t2 VALUES(1, 1);

SELECT * FROM t1 NATURAL JOIN t2;

j
i
k

1
1
1

SELECT * FROM t1 INNER JOIN t2 USING (j);

j
i
k

1
1
1

SELECT * FROM t1 JOIN t2 USING (j);

j
i
k

1
1
1

SELECT * FROM t1 LEFT JOIN t2 USING (j);

j
i
k

1
1
1

SELECT * FROM t1 RiGHT JOIN t2 USING (j);

j
k
i

1
1
1

SELECT * FROM t1 LEFT JOIN t2 ON (t1.j = t2.j);

i
j
k
j

1
1
1
1

SELECT * FROM t1 RIGHT JOIN t2 ON (t1.j = t2.j);

i
j
k
j

1
1
1
1

SELECT * FROM t1 INNER JOIN t2 ON (t1.j = t2.j);

i
j
k
j

1
1
1
1