As you progress, you’ll find situations where you need to combine more than one data pull to answer your question. In these situations, you’ll use subqueries and join or filter the results from these. Actually, you already have seen some subqueries in the examples from the last 2 posts. This post aims to provide an
Tag: joins
When to use more complex joins
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