Stack results: UNION and UNION ALL · exercise 1 of 1 · free preview
UNION stacks the rows of two SELECTs into one list and removes repeated rows. It is like pasting two ranges together in Excel and removing duplicates.
Make one list in a column called name: every customer's last name and every product's name. Sort the list by name.
Tables in this practice shop
customersproductsordersorder_items