SQL INNER JOIN – Syntax, Examples, and Use Cases

Introduction – What is INNER JOIN?

INNER JOIN is the most commonly used SQL JOIN. It returns rows that have matching values in both tables based on a specified condition.

In this guide, you’ll learn:

• Syntax and structure of INNER JOIN
• Use cases and benefits
• Best practices for writing efficient joins

1. INNER JOIN Syntax

SELECT columns
FROM table1
INNER JOIN table2 ON table1.common_column = table2.common_column;

Returns records where common_column matches in both tables.

2. Example – Employees and Departments

SELECT e.name, d.name AS department
FROM employees e
INNER JOIN departments d ON e.department_id = d.id;

Displays only employees who are assigned to departments.

3. INNER JOIN with Multiple Conditions

SELECT o.id, c.name, o.total
FROM orders o
INNER JOIN customers c
  ON o.customer_id = c.id AND o.status = 'completed';

Filters join using both foreign key and status.

4. INNER JOIN Across More Than Two Tables

SELECT e.name, d.name AS department, l.city
FROM employees e
INNER JOIN departments d ON e.department_id = d.id
INNER JOIN locations l ON d.location_id = l.id;

Combines employees, departments, and location data.

5. INNER JOIN vs WHERE

-- JOIN syntax
FROM a
INNER JOIN b ON a.id = b.a_id

-- WHERE syntax (equivalent result)
FROM a, b
WHERE a.id = b.a_id

JOIN syntax is cleaner, more readable, and standard.

6. INNER JOIN Excludes Non-Matching Rows

Rows from either table that don’t meet the join condition are not returned.
Use LEFT JOIN or FULL OUTER JOIN if you want unmatched rows.

Best Practices

Summary – Recap & Next Steps

INNER JOIN is the default and most efficient join type when you only need related records. It enables normalized data querying across multiple tables.

Key Takeaways:

• Use INNER JOIN to match rows from both tables
• Conditions go in the ON clause
• Can be used with multiple tables and filters

Real-World Relevance:
Used in reporting systems, database views, multi-table dashboards, and real-time queries.

Next: Learn about LEFT JOIN to include unmatched rows from the left table.

FAQ – SQL INNER JOIN

What does INNER JOIN do?

It returns only the rows that have matches in both joined tables.

How is INNER JOIN different from LEFT JOIN?

INNER JOIN excludes unmatched rows; LEFT JOIN includes all rows from the left table.

Can I use WHERE instead of ON?

You can, but ON is preferred for readability and SQL standards.

Can I join more than two tables?

Yes, INNER JOIN can be chained to combine as many tables as needed.