The inner join is a set intersection and is the default behavior. This join returns rows that have matching values in both tables:

The following query does an inner join:

SELECT Reservations.ReservationId, Customers.CustomerName,Reservations.Date
    FROM Orders
    INNER JOIN Customers 
    ON Orders.CustomerID=Customers.CustomerID;
  

It produces the following result: