4 ms·
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.
by iimblack 7y ago
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 7y agoOh 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 7y agoYes, that should work.