Why joins are needed in SQL

Introduction

Joins help combine data from two or more tables to see related information together. This is useful because data is often stored in separate tables to keep it organized.

You want to see customer details along with their orders.

You need to find employees and the departments they work in.

You want to list products along with their supplier information.

You want to combine student records with their grades from different tables.

Syntax

SQL

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

The JOIN keyword connects rows from two tables based on a related column.

The ON clause specifies the condition to match rows between tables.

Examples

This query shows customer names with their order IDs by joining Customers and Orders tables on CustomerID.

SQL

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

This query lists employees with their department names by joining Employees and Departments tables.

SQL

SELECT Employees.Name, Departments.DepartmentName
FROM Employees
JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID;

Sample Program

This example creates two tables, Customers and Orders, inserts sample data, and then joins them to show each customer's products.

SQL

CREATE TABLE Customers (CustomerID INT, Name VARCHAR(50));
CREATE TABLE Orders (OrderID INT, CustomerID INT, Product VARCHAR(50));

INSERT INTO Customers VALUES (1, 'Alice'), (2, 'Bob');
INSERT INTO Orders VALUES (101, 1, 'Book'), (102, 2, 'Pen'), (103, 1, 'Notebook');

SELECT Customers.Name, Orders.Product
FROM Customers
JOIN Orders ON Customers.CustomerID = Orders.CustomerID
ORDER BY Customers.Name;

Important Notes

Without joins, you would have to look at each table separately and try to match data manually.

Joins make it easy to combine related data and answer questions that involve multiple tables.

Summary

Joins combine data from multiple tables based on related columns.

They help you see connected information in one result.

Joins are essential for working with organized, multi-table databases.