This is an old revision of the document!

How does full join work???

Despite I am seasoned sql developer, sometimes I have doubts on how exactly full join work; so I decided to implement this simple test to see this working.

Let's say we have two tables:

create table test1
(field  varchar2(100));

create table test2
(field varchar2(100));

-- unique values for table test1 
insert into test1 values ('a');
insert into test1 values ('b');
insert into test1 values ('c');