Problem: 1068. 产品销售分析 I
思路
- left join on:左连接
Code
select p.product_name, s.year, s.price
from Sales s
left join Product p
on s.product_id = p.product_id
Problem: 1068. 产品销售分析 I
select p.product_name, s.year, s.price
from Sales s
left join Product p
on s.product_id = p.product_id