Error Code: 1054. Unknown column ‘oi.unit_prize’ in ‘field list’
I got this Error Code with the following code:
SELECT oi.product_id, name, oi.quantity, oi.unit_prize
FROM order_items AS oi
JOIN products AS p
ON p.product_id = oi.product_id
Thank you for your help.