Guidehouse interview question

Describe an inner join in SQL.