Re:What's the strangest code you've seen a senior developer ...
by dotancohen on Sunday March 27, 2022 @06:26AM
(#30819170)
You can filter on the left table by putting the conditions in the ON clause.
[ Parent
| on HN ]
Re:What's the strangest code you've seen a senior developer ...
by xupybd on Sunday March 27, 2022 @02:11PM
(#30822523)
Exactly you can but then your query has multiple places to examine if you want to know what out you should expect. By having it all in the where clause it can read a little better.