SQL – Inner Joins
Table Of Contents:
- What Is SQL Inner Join?
- Syntax Of SQL Inner Join.
- Examples Of SQL Inner Join.
(1) What Is SQL Inner Joins?
- The
INNER JOIN
keyword selects records that have matching values in both tables.
(2) Syntax Of SQL Inner Joins?
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
(3) Examples Of SQL Inner Joins?
Order Table:
Customer Table:
Example-1: Joining Two Tables
SELECT Orders.OrderID, Customers.CustomerName
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
Example-2: Joining Three Tables
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);