Addteq interview question

What is foreign key and join in database?