06A
Compare these references after your own attempt. You can read them at any time; they do not record a live model or vendor run.
Compare these references after your own attempt. You can read them at any time; they do not record a live model or vendor run.
-- 06a: Join products to lines
SELECT i.order_id,i.line_no,p.product_name,i.quantity
FROM aabha_sql.order_items AS i JOIN aabha_sql.products AS p ON p.product_id=i.product_id
WHERE i.order_id=1001 ORDER BY i.line_no;