how to select a column from one table according to another table column?

how to select a column from one table according to another table column?

References

Reference NO 1

http://stackoverflow.com/questions/11849372/insert-into-one-column-by-selecting-another-column-in-other-table-but-how-fill-t

Reference NO 2

http://stackoverflow.com/questions/3492904/mysql-select-all-columns-from-one-table-and-some-from-another-table

Reference NO 3

http://stackoverflow.com/questions/10181123/sql-query-to-get-data-from-one-table-based-upon-a-column-from-another-table

Reference NO 4

http://stackoverflow.com/questions/8546068/copy-values-from-one-table-to-another-based-on-column-comparison

Reference NO 5

http://www.dbforums.com/oracle/1629930-set-one-column-another-tables-column-update.html

Reference NO 6

http://technet.microsoft.com/en-us/library/ms187654.aspx

Reference NO 7

#EANF#

Reference NO 8

#EANF#