Combine tables with JOIN · exercise 1 of 1 · free preview
JOIN … ON matches rows whose keys are equal. Short names (aliases) like o and c keep queries readable.
Show the order_id and the customer's last_name for every order that has a customer. Orders without a customer are left out.
Tables in this practice shop
customersproductsordersorder_items