MySQL 8.0

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

CREATE tABLE t1(id int, col_1 varchar(50))
INSERT INTO t1 VALUES (1,'Tim'),(2,'Martqa')
CREATE tABLE t2(id int, col_2 varchar(50))
INSERT INTO t2 VALUES (1,'Tim'),(3,'Katarina')
SeLECT t1.id, t1.col_1,t2.col_2
FROM t1 LEFT JOIN t2 USING(id)
UNION 
SeLECT t2.id, t1.col_1,t2.col_2
FROM t1 RIGHT JOIN t2 USING(id)


id
col_1
col_2


1
Tim
Tim

2
Martqa
null

3
null
Katarina


SeLECT t1.id, t1.col_1,t2.col_2
FROM t1 LEFT JOIN t2 USING(id)
WHERE t1.id > 1
UNION 
SeLECT t2.id, t1.col_1,t2.col_2
FROM t1 RIGHT JOIN t2 USING(id)
WHERE t2.id > 1


id
col_1
col_2


2
Martqa
null

3
null
Katarina


SELECT * FROM
(SeLECT t1.id, t1.col_1,t2.col_2
FROM t1 LEFT JOIN t2 ON t1.id = t2.id 
UNION 
SeLECT t2.id, t1.col_1,t2.col_2
FROM t1 RIGHT JOIN t2 ON t1.id = t2.id) t1
WHERE id > 1


id
col_1
col_2


2
Martqa
null

3
null
Katarina