Eight join questions with the traps from this unit. Before each join, ask: is the key unique on the side I expect, should every row on the left survive, and does the key need a date?
The data: df (orders), customers, products, price_history, targets, and rentals with stations.