Keep unmatched rows from both sides: RIGHT and FULL JOIN · exercise 1 of 1 · free preview
RIGHT JOIN is a LEFT JOIN with the tables swapped: every row of the right table is kept, and the left side is NULL where nothing matches.
Show every order's order_id with its customer's last_name, including orders with no customer. Use a RIGHT JOIN on orders. Order by order_id.
Tables in this practice shop
customersproductsordersorder_items