1068. Product Sales Analysis I 难度：简单

1、题目描述

Write an SQL query that reports all product names of the products in the Sales table along with their selling year and price.
For example:
Sales table:

sale_id	product_id	year	quantity	price
1	100	2008	10	5000
2	100	2009	12	5000
7	200	2011	15	9000

Product table:

product_id	product_name
100	Nokia
200	Apple
300	Samsung

Result table:

product_name	year	price
Nokia	2008	5000
Nokia	2009	5000
Apple	2011	9000

来源：力扣（LeetCode）

2、解题思路

就是外连接嘛。

3、提交记录

select product_name,`year`,price
from Sales s left join product p
on s.product_id=p.product_id