Business Analyst: What is an INNER JOIN vs LEFT JOIN?

1-- INNER JOIN: Only customers with orders
2SELECT c.name, o.total
3FROM customers c
4INNER JOIN orders o ON c.id = o.customer_id;
5Result: 3 rows (only customers with orders)
6
7-- LEFT JOIN: All customers, even without orders
8SELECT c.name, o.total
9FROM customers c
10LEFT JOIN orders o ON c.id = o.customer_id;
11Result: 5 rows (all customers, NULL for no orders)