As you pull your data more often, you may encounter situations where you need more complex joins than what we’ve previously discussed. Here are some examples: You’re looking for something that did not happen: e.g. products without orders in the past 7 days. In this case, you need an outer join. Specifically, you would pull