When Moving a Filter Broke My Join

While working through examples for the JOINs SQL article, I thought I had a simple LEFT JOIN doing what I needed. I was trying to pull a list of products, keeping them all in the result, but only showing stock data if the product had more than zero units. Easy enough, right?

So I dropped in this query:

It looked good at first. But the more I poked at it, …