FULL OUTER JOIN : Analysis

create table wwt_test_config ( org_id number, item_id number, quantity number);
create table wwt_test_lpn ( org_id number, item_id number, quantity number);

Case 1

insert into wwt_test_config VALUES ( 2434, 1234, 1);
insert into wwt_test_config VALUES ( 2434, 5678, 2);
insert into wwt_test_config VALUES ( 2434, 8761, 6);
insert into wwt_test_config VALUES ( 2434, 4321, 7);



insert into wwt_test_lpn VALUES ( 2434, 1234, 1);
insert into wwt_test_lpn VALUES ( 2434, 5678, 2);
insert into wwt_test_lpn VALUES ( 2434, 8761, 6);
insert into wwt_test_lpn VALUES ( 2434, 4321, 7);
insert into wwt_test_lpn VALUES ( 2434, 9999, 17);


ORG_ID ITEM_ID QUANTITY ORG_ID_1 ITEM_ID_1 QUANTITY_1
2434 1234 1                 2434 1234 1
2434 5678 2                 2434 5678 2
2434 8761 6                 2434 8761 6
2434 4321 7                 2434 4321 7
                                2434 9999 17



Case 2

insert into wwt_test_config VALUES ( 2434, 1234, 1);
insert into wwt_test_config VALUES ( 2434, 5678, 2);
insert into wwt_test_config VALUES ( 2434, 8761, 6);
insert into wwt_test_config VALUES ( 2434, 4321, 7);
insert into wwt_test_config VALUES ( 2434, 9999, 17);


insert into wwt_test_lpn VALUES ( 2434, 1234, 1);
insert into wwt_test_lpn VALUES ( 2434, 5678, 2);
insert into wwt_test_lpn VALUES ( 2434, 8761, 6);
insert into wwt_test_lpn VALUES ( 2434, 4321, 7);


ORG_ID ITEM_ID QUANTITY ORG_ID_1 ITEM_ID_1 QUANTITY_1
2434 1234 1                  2434 1234 1
2434 5678 2                  2434 5678 2
2434 8761 6                  2434 8761 6
2434 4321 7                  2434 4321 7
2434 9999 17



Case 3

insert into wwt_test_config VALUES ( 2434, 1234, 1);
insert into wwt_test_config VALUES ( 2434, 5678, 2);
insert into wwt_test_config VALUES ( 2434, 8761, 6);
insert into wwt_test_config VALUES ( 2434, 4321, 7);
insert into wwt_test_config VALUES ( 2434, 9999, 17);


insert into wwt_test_lpn VALUES ( 2434, 1234, 1);
insert into wwt_test_lpn VALUES ( 2434, 5678, 2);
insert into wwt_test_lpn VALUES ( 2434, 8761, 6);
insert into wwt_test_lpn VALUES ( 2434, 4321, 7);
insert into wwt_test_lpn VALUES ( 2434, 1111, 17);

ORG_ID ITEM_ID QUANTITY ORG_ID_1 ITEM_ID_1 QUANTITY_1
2434 1234 1                 2434 1234 1
2434 5678 2                 2434 5678 2
2434 8761 6                 2434 8761 6
2434 4321 7                 2434 4321 7
                                2434 1111 17
2434 9999 17