select product_name ,year , price from Sales join Product on Product.product_id=Sales. product_id; MySQL中的join以及on条件的用法_mysql join on用法_还没想好116的博客-优快云博客