How to update from other table based on sequence?

How to update from other table based on sequence?

References

Reference NO 1

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/views.htm

Reference NO 2

https://dev.mysql.com/doc/refman/5.6/en/glossary.html

Reference NO 3

http://stackoverflow.com/questions/8761448/jpa-table-sequence-does-not-exist

Reference NO 4

http://docs.sqlalchemy.org/en/rel_0_7/core/schema.html

Reference NO 5

http://www.databasejournal.com/features/mssql/generating-sequence-numbers-using-the-sequence-object.html

Reference NO 6

http://www.codeproject.com/Articles/491733/Auto-generated-sequence-number-in-SQL-Server

Reference NO 7

http://www.postgresql.org/docs/8.1/static/sql-createsequence.html

Reference NO 8

http://hsqldb.org/doc/guide/databaseobjects-chapt.html