What is SQL Natural Join?

Natual Join is a type of join in SQL which combines row from 2 tables based on common column which has same name and datatype. It automatically matches the 2 columns and eliminates the duplicate column. read more

Example

Database

CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Email VARCHAR(100),
    City VARCHAR(50)
);
CustomerIDFirstNameLastNameEmailCity
1JohnDoejohn.doe@example.comNew York
2JaneSmithjane.smith@example.comLos Angeles
3EmilyJohnsonemily.j@example.comChicago

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
    City VARCHAR(50),
    FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);
OrderIDCustomerIDOrderDateTotalAmountCity
10112024-01-10250.50New York
10222024-01-11150.00Los Angeles
10332024-01-12300.75Chicago

Syntax

SELECT *

FROM TABLE1

NATURAL JOIN TABLE2;

Query

SELECT * 
FROM Orders
NATURAL JOIN Customers;

SQL Natural Join

Explanation

In this scenario, SQL combines the Orders and Customers tables using a natural join. The join is performed based on the common columns, CustomerID and City, which appear at the beginning of the resulting table.

As a result, SQL brings together columns like FirstName, LastName, and Email from the Customers table, along with OrderID, OrderDate, and TotalAmount from the Orders table. The shared columns, CustomerID and City, are seamlessly included in the result without duplication, making the output clear and concise.


I hope this explanation was helpful for you, consider sharing this with your friends. thank you.

Spread the love

Recent Posts

Python Practice Questions & Solutions Day 5 of Learning Python for Data Science

Python Practice Questions & Solutions Day 5 of Learning Python for Data Science Welcome back…

5 days ago

Day 5 of Learning Python for Data Science: Data Types, Typecasting, Indexing, and Slicing

Day 5 of Learning Python for Data Science: Data Types, Typecasting, Indexing, and Slicing Understanding…

5 days ago

Python Practice Questions & Solutions Day 4 of Learning Python for Data Science

Python Practice Questions & Solutions Day 4 of Learning Python for Data Science Welcome back…

5 days ago

Day 4 of Learning Python for Data Science

Day 4 of Learning Python for Data Science Day 4 of Learning Python for Data…

5 days ago

Practice Questions and Answers for Day 3 of Learning Python for Data Science

Test your Python skills with these 20 practice questions and solutions from Day 3 of…

6 days ago

Day 3 of Learning Python for Data Science

Understanding Python’s conditional statements is essential for controlling the flow of a program. Today, we…

6 days ago