how to get name from another table with matching id in another table?

how to get name from another table with matching id in another table?

References

Reference NO 1

http://stackoverflow.com/questions/15193986/how-to-get-name-from-another-table-with-matching-id-in-another-table

Reference NO 2

http://stackoverflow.com/questions/13590102/mysql-select-column-from-one-table-to-match-up-with-another-table-to-pull-id

Reference NO 3

http://stackoverflow.com/questions/8491770/php-mysql-select-id-from-one-table-and-information-from-another-table

Reference NO 4

http://stackoverflow.com/questions/7602034/sql-match-records-from-one-table-to-another-table-based-on-several-columns

Reference NO 5

http://stackoverflow.com/questions/5446778/sql-select-from-one-table-matching-criteria-in-another

Reference NO 6

#EANF#

Reference NO 7

#EANF#

Reference NO 8

#EANF#