PostgreSQL Full Outer Join

In today’s article, I will be explaining FULL OUTER JOIN, which is the combined version of LEFT OUTER and RIGHT OUTER JOIN in PostgreSQL.

In FULL OUTER JOIN, all records from both tables are returned, but uncorrelated columns are returned as empty.

SELECT s.SehirIsmi,my.YiyecekIsmi FROM Sehirler s FULL OUTER JOIN MeshurYiyecekler my on s.id=my.sehirid;

1	SELECT s.SehirIsmi,my.YiyecekIsmi FROM Sehirler s FULL OUTER JOIN MeshurYiyecekler my on s.id=my.sehirid;

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux