FDM Group interview question

What is an inner join in SQL?