Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Remko1981
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
3 ms
·
1.
▲
by
Remko1981
5y ago
What a lot of people do not realize is that they are making implicit inner joins because of the way they use the where clauses. When you say 'where left join column = some value' you exclude all rows containing NULL in that column