3 ms·
Yeah and if you put everything in as left joins filtering only happens in the where clause. It becomes easier to understand why rows are missing. I've done this
by xupybd 5y ago
Yeah and if you put everything in as left joins filtering only happens in the where clause. It becomes easier to understand why rows are missing. I've done this in the past when I wanted to make it obvious that x was getting filtered out of the result set.
- dotancohen 5y agoYou 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.