Combine Data from Multiple Tables Using LEFT JOIN

SELECT
    c.customer_id,
    c.first_name,
    c.last_name,
    o.order_id,
    o.order_date,
    o.order_total
FROM
    customers c
LEFT JOIN
    orders o ON c.customer_id = o.customer_id
WHERE
    o.order_id IS NULL
    OR o.order_date >= '2023-01-01';

How it works: This snippet uses a `LEFT JOIN` to combine data from the `customers` and `orders` tables. It returns all records from the `customers` table (the 'left' table), and the matching records from the `orders` table (the 'right' table). If a customer has no matching orders, the order-related columns will be `NULL`. The `WHERE` clause then filters to show either customers with no orders or those with orders placed on or after a specific date.