Mastercard interview question

How inner join works in SQL?