Beginner

443. EQUI JOIN

Understand EQUI JOIN and how equality conditions are used to match records between tables.

📘 Lesson 443 of 728 ⏱ 10 min 🎯 Intermediate

An EQUI JOIN is a join that matches rows using an equality condition, typically with the equals operator.

Most common relational joins use equality between matching key columns.

Match employees with their departments using DepartmentID.

SQL 
SELECT
    e.EmployeeName,
    d.DepartmentName
FROM Employees e
INNER JOIN Departments d
    ON e.DepartmentID = d.DepartmentID;

EQUI JOIN logic is widely used in employee, customer, sales, account, and transaction reporting.

  • EQUI JOIN uses equality to match rows.
  • The equals operator is commonly used.
  • Primary and foreign keys are often matched.
  • INNER JOIN commonly uses EQUI JOIN logic.
  • It is one of the most common join patterns.
What is an EQUI JOIN?

An EQUI JOIN matches records between tables using an equality condition.

Which operator is commonly used in an EQUI JOIN?

The equals operator (=) is commonly used.

Have you finished this lesson?

Introduction to SQL – All Lessons