Guidehouse Interview Question

Describe an inner join in SQL.