Manulife interview question

Could you please explain inner join?