USE store;
SELECT
oi.order_id,
oi.product_id,
oi.quantity,
oi.unit_price,
oin.note
FROM order_items oi
JOIN order_item_notes oin
on oi.order_id = oin.order_Id
AND oi.product_id = oin.product_id
I have prepared this query and when i run it i should get values as there are values on these table columns in the database.
Can you please help find my mistake
The order_item_notes table in the course material does not contain entries that match any entries in the order_items table. Both notes refer to order_id 1 and product_id 2 while the order_items for order_id 1 just contain an entry with product_id 4.
So your query is OK. If you insert rows into order_item_notes that match an order_item row it will work.
