SQL Natural Join

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)
);

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
    City VARCHAR(50),
    FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);

Syntax

SELECT *

FROM TABLE1

NATURAL JOIN TABLE2;

Query

SELECT * 
FROM Orders
NATURAL JOIN Customers;

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.

• Day 13 of Learning Python for Data Science: Mastering Pivot, Apply and RegEx
• Practice day 12 of Learning Python for Data Science
• Day 12 of Learning Python for Data Science – Pandas
• Day 10 Of Learning Python for Data Science – NumPy Array In Python
• Day 9 of Learning Python for Data Science – Queries Related To Functions In Python