INNER JOIN WITH SELECT code example

Example 1: sql select inner join example

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

Example 2: Inner join sql

SELECT column_name(s)

FROM table1

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