PostgreSQL/Table Joins/Full Join
FULL JOIN two tables ON
<source lang="sql">
postgres=# postgres=# CREATE TABLE t1 ( postgres(# num int, postgres(# name varchar(10) postgres(# ); CREATE TABLE postgres=# postgres=# insert into t1 values(1,"a"); INSERT 0 1 postgres=# insert into t1 values(2,"b"); INSERT 0 1 postgres=# insert into t1 values(3,"c"); INSERT 0 1 postgres=# postgres=# CREATE TABLE t2 ( postgres(# num int, postgres(# name varchar(10) postgres(# ); CREATE TABLE postgres=# postgres=# insert into t2 values(1,"xxx"); INSERT 0 1 postgres=# insert into t2 values(3,"yyy"); INSERT 0 1 postgres=# insert into t2 values(5,"zzz"); INSERT 0 1 postgres=# postgres=# SELECT * FROM t1 FULL JOIN t2 ON t1.num = t2.num;
num | name | num | name
+------+-----+------
1 | a | 1 | xxx 2 | b | | 3 | c | 3 | yyy | | 5 | zzz
(4 rows) postgres=# postgres=# drop table t1; DROP TABLE postgres=# drop table t2; DROP TABLE postgres=#
</source>