full outer join by hand

full outer join by hand

References

Reference NO 1

http://stackoverflow.com/questions/15197992/full-outer-join-by-hand

Reference NO 2

http://www.postgresql.org/docs/9.0/static/sql-select.html

Reference NO 3

http://dcx.sybase.com/1200/en/dbusage/outer-joinsasp.html

Reference NO 4

http://office.microsoft.com/en-us/access-help/creating-an-outer-join-query-in-access-HA001034555.aspx

Reference NO 5

http://scn.sap.com/community/semantic-layer/blog/2013/07/22/full-outer-join-at-universe

Reference NO 6

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

Reference NO 7

http://www.sqlforge.com/w/Outer_joins

Reference NO 8

http://www.techonthenet.com/sql/joins.php