sql select from foreign key code example

Example: What is foreign key?

Foreign Key is a non-key attribute which is derived from the primary key 
of another table which links those tables together.