Manulife Interview Question

Could you please explain inner join?