SQL SELECT and UPDATE Returns Different Result

SQL SELECT and UPDATE Returns Different Result

References

Reference NO 1

http://stackoverflow.com/questions/15198918/sql-select-and-update-returns-different-result

Reference NO 2

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

Reference NO 3

http://dba.stackexchange.com/questions/11898/oracle-returns-different-results-when-executing-a-sql-with-bind-variable-or-with

Reference NO 4

http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/ad/c0011133.htm

Reference NO 5

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 6

https://www.simple-talk.com/sql/learn-sql-server/update--basics-in-sql-server/

Reference NO 7

http://en.wikipedia.org/wiki/Select_(SQL)

Reference NO 8

http://bugs.mysql.com/30643