SQL Joins (Inner, Left, Right, Full)

Objective

Combine and compare data from multiple related tables using SQL "JOIN" operations.

Tables Used

1. Customers – Stores customer information
2. Orders – Stores order details linked to Customers using customer_id

SQL Concepts Demonstrated

1. INNER JOIN – Returns records with matching values in both tables.
2. LEFT JOIN – Returns all records from the left table (Customers) and matched records from the right (Orders).
3. RIGHT JOIN – Returns all records from the right table (Orders) and matched records from the left (Customers).
4. FULL JOIN – Returns all records when there is a match in either table.

Outcome

• Merge data from multiple tables
• Understand the difference between join types