Understanding SQL JOIN with Examples

SQL JOIN

In SQL, the JOIN clause is used to combine data from two or more tables in a relational database. This process allows you to retrieve information that exists across multiple tables efficiently.

Complete Python Course with Advance topics:-Click Here
SQL Tutorial :-Click Here

What is SQL JOIN?

The SQL JOIN clause is designed to merge records from multiple tables into one result set by using a common field. There are five primary types of JOIN defined by ANSI SQL standards:

INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
CROSS JOIN

Why Use SQL JOIN?

SQL JOINs are essential when:

You need to query data that is stored in multiple tables.
You want to merge rows from these tables into one comprehensive result set.

The merging process is based on a common field that both tables share. Among all types, the INNER JOIN is the most commonly used JOIN.

SQL INNER JOIN Example

Let’s understand the SQL JOIN concept using an example with updated table data.

Employee Table

ID	Employee_NAME	Employee_AGE	Employee_ADDRESS	Salary
1	Rahul	28	Pune	30000
2	Neha	34	Bangalore	40000
3	Aryan	25	Delhi	28000
4	Simran	30	Chandigarh	35000

Salary_Payment Table

Payment_ID	DATE	Employee_ID	AMOUNT
201	15/01/2023	1	5000
202	20/02/2023	3	4500
203	25/03/2023	4	6000

Using SQL INNER JOIN to Combine Data

To combine these tables and retrieve data about employees and their payment details, you can use the following query:

SELECT e.ID, e.Employee_NAME, e.Employee_AGE, sp.AMOUNT
FROM Employee e
JOIN Salary_Payment sp
ON e.ID = sp.Employee_ID;

Result Set

ID	Employee_NAME	Employee_AGE	AMOUNT
1	Rahul	28	5000
3	Aryan	25	4500
4	Simran	30	6000

Explanation

The INNER JOIN merges records where the ID in the Employee table matches the Employee_ID in the Salary_Payment table.
Only matching rows from both tables appear in the result set.

Download New Real Time Projects :-Click here
Complete Advance AI topics:- CLICK HERE

Key Takeaways

SQL JOIN helps in effectively combining related data from multiple tables.
Using proper joins ensures accurate and comprehensive results.

For a detailed understanding of other JOIN types, stay tuned to UpdateGadh for insightful tutorials and guides!

sql join 3 tables
joins in sql with examples
sql join types
self join in sql
cross join in sql

Post Views: 712