On: Handling Null Values in Postgres

[iimblack]

Doesn't this produce different output? I could be wrong but I think your code is more equivalent to an inner join, not a left outer join.

[magicalhippo → iimblack]

Oh yeah you're right, I read the comment above the query and assumed he wanted only customers which had orders.

Could just modify it to exclude the orders above 100 ("where not exists"...), no?

[iimblack → magicalhippo]

Yes, that should work.