Sto seguendo un tutorial di sql *** precisamente sono a compito 6 challange 1
Ho fatto copia e incolla della soluzione
-- Write an SQL query that reports all product names
-- of the products in the Sales table along with their selling year and price.
SELECT
p.product_name,
s.year,
s.price
FORM product p
INNER JOIN sales s
ON s.product_id = p.product_id;
ma mi da errore...
15:34:10 SELECT p.product_name, s.year, s.price FORM product p INNER JOIN sales s ON s.product_id = p.product_id Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'product p INNER JOIN sales s ON s.product_id = p.product_id' at line 5 0.000 sec
Che cosa c'è che non va?