inner join

SELECT column_name(s)

FROM table1

INNER JOIN table2
 ON table1.column_name = table2.column_name;
 

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

INNER JOIN: Only some portion of the tables which is matching.
Inner join eliminates if there is no match.

  SELECT Orders.OrderID, Customers.CustomerName, Shippers.ShipperName
FROM 
  ((Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID)

  INNER JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID);