2 ms·
Indeed, I've taught myself to only use JOIN when I actually need some data from the table I join. For everything else I use EXISTS and friends. I was thinking
by magicalhippo 5y ago
Indeed, I've taught myself to only use JOIN when I actually need some data from the table I join. For everything else I use EXISTS and friends.
I was thinking SQL could do with a keyword for that, like maybe FILTER, that looks like a JOIN but works like EXISTS.
- snidane 5y agoClickhouse implements an explicit SEMI join. It can be called semi or any, it doesn't really matter. It's just another join modifier [OUTER|SEMI|ANTI|ANY|ASOF] https://clickhouse.com/docs/en/sql-reference/statements/select/join/ https://clickhouse.com/docs/en/sql-reference/statements/sele...