Mastercard Interview Question

How inner join works in SQL?