4 ms·
You can filter on the left table by putting the conditions in the ON clause.
by dotancohen 5y ago
You can filter on the left table by putting the conditions in the ON clause.
- xupybd 5y agoExactly 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.