mysql学习打卡day23

今日成果：

SELECT 
    customer_id, first_name, last_name
FROM
    customers
WHERE
    customer_id IN (SELECT 
            customer_id
        FROM
            orders
        WHERE
            order_id IN (
            SELECT 
                    order_id
                FROM
                    order_items
                WHERE
                    product_id = 3)
                    );
                    
select distinct customer_id,first_name,last_name
from customers c 
left join orders o using (customer_id)
left join order_items oi using (order_id)
where oi.product_id = 3;
-- 两种不同方法查询同一个数据

感谢各位读者查阅，欢迎各位👍点赞✍评论⭐收藏+关注！