From VLOOKUP to JOIN · exercise 1 of 1 · free preview
In Excel, VLOOKUP(product_id, products, 3, FALSE) fetches a value from the matching row. In SQL the same job is a JOIN on the key.
For every order item, show order_item_id, the product name and the unit price, just as a VLOOKUP on product_id would.
Tables in this practice shop
customersproductsordersorder_items