Update data in Multiple table

Update data in Multiple table

References

Reference NO 1

http://stackoverflow.com/questions/15193886/update-data-in-multiple-table

Reference NO 2

http://stackoverflow.com/questions/13357037/mysql-update-with-selected-data-according-to-multiple-tables

Reference NO 3

http://office.microsoft.com/en-us/access-help/video-use-an-update-query-to-change-data-in-multiple-tables-VA104092866.aspx

Reference NO 4

http://forums.devx.com/showthread.php?148804-SQL-Insert-data-in-Multiple-table-and-Update-at-same-time

Reference NO 5

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/sqlp/rbafyupdate.htm

Reference NO 6

http://robertoschiabel.wordpress.com/2010/06/06/sql-update-data-from-join-with-other-tables/

Reference NO 7

http://blog.sqlauthority.com/2013/04/30/sql-server-update-from-select-statement-using-join-in-update-statement-multiple-tables-in-update-statement/

Reference NO 8

http://decipherinfosys.wordpress.com/2007/01/31/update-data-in-one-table-with-data-from-another-table/