my sql 学习 子查询VS连接

子查询

use sql_store;
select *
from customers
where customer_id in ( -- 使用子查询得出订购产品3的顾客ID后筛选定位顾客表中的顾客
select o.customer_id
from order_items oi
join orders o
using(order_id) -- order_items和orders 表内连接
where product_id = 3) -- 筛选得出订购了产品3的顾客ID

连接

use sql_store;
select distinct c.customer_id,c.first_name,c.last_name
from customers c
join orders o
on c.customer_id = o.customer_id
join order_items oi
on oi.order_id = o.order_id
where oi.product_id = 3 
order by customer_id