inner join sql

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;

 SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

 

  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);