INNER JOIN

The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables.




SQL INNER JOIN Syntax


SELECT column_name(s)


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






Example:






SELECT Customers.CustomerName, Orders.OrderID

FROM Customers

INNER JOIN Orders

ON Customers.CustomerID=Orders.CustomerID

ORDER BY Customers.CustomerName;