SQL Joins Examples

JOIN Example 1: Basic Joins

This example demonstrates a simple join between two tables, 'Customers' and 'Orders'. We want to retrieve all customers and their orders.

• Customer

  John Doe

• Order

  Order ID: 12345

JOIN Example 2: LEFT JOIN

This example demonstrates a LEFT JOIN to ensure all customers are included, even if they don't have any orders.

• Customer

  Alice Smith

• Order

  Order ID: 67890

JOIN Example 3: RIGHT JOIN

This example demonstrates a RIGHT JOIN to include all orders, even if they don't have any customers.

• Order

  Order ID: 11223

• Customer

  Bob Jones