Every combination: CROSS JOIN, and the USING shortcut · exercise 1 of 1 · free preview
When both tables have a column with the same name, JOIN orders USING (customer_id) is a shorter way to write ON c.customer_id = o.customer_id.
Show the last name and order_id of every order that belongs to a customer. Join customers and orders with USING (customer_id). Order by order_id.
Tables in this practice shop
customersproductsordersorder_items