MySQL create view joining two whole tables

MySQL create view joining two whole tables

References

Reference NO 1

http://stackoverflow.com/questions/15187751/mysql-create-view-joining-two-whole-tables

Reference NO 2

http://stackoverflow.com/questions/13656864/sql-create-view-from-multiple-tables

Reference NO 3

http://www.informit.com/articles/article.aspx?p=30875&seqNum=5

Reference NO 4

http://www.mysqlperformanceblog.com/2007/08/12/mysql-view-as-performance-troublemaker/

Reference NO 5

http://www.techotopia.com/index.php/An_Introduction_to_MySQL_Views

Reference NO 6

http://www.xaprb.com/blog/2006/05/26/how-to-write-full-outer-join-in-mysql/

Reference NO 7

http://www.java2s.com/Tutorial/MySQL/0180__View/Creatingaviewbyjoiningtwotables.htm

Reference NO 8

http://net.tutsplus.com/tutorials/databases/introduction-to-mysql-views/