4 ms·
Nothing unusual there. Left joins (or right joins, but that sounds like the opposite of the way I see tables in my head) are the most useful in day to day life
by jokethrowaway 5y ago
Nothing unusual there.
Left joins (or right joins, but that sounds like the opposite of the way I see tables in my head) are the most useful in day to day life.
I don't think I ever shipped a crossjoin for perf reasons and very rarely I needed the intersection of two tables.
Most likely the op never was in a situation to need those.
- setr 5y agoIf he really never used an inner join though, that’d just be weird. I’ve never come across an outer join or right join usecase in practice… but definitely inner joins…
- goto11 5y agoSure, but an inner join is just a left join with a not-null constraint. More syntax, but not a lot. I can see how someone might prefer left joins for consistency.
- xupybd 5y agoCross joins are great against calendar tables. If you want to generate a periodic item.