News for hackers. Stuff that matters.
Re:What's the strangest code you've seen a senior developer ... by goto11 on Sunday March 27, 2022 @04:46AM (#30818750)
Right join is just left join with the clauses switched, so it makes sense to use left join consistently. Inner join is just a left join with a 'not null' condition. I prefer inner join for conciseness, but it makes sense to always chose left join for consistency. Full outer joins are rarely needed in my experience.

In any case, all the joins are just syntactic sugar over cross product. AFAIK SQL did not have the join syntax initially, you just did SELECT foo, bar WHERE foo.id = bar.foo_id

Re:What's the strangest code you've seen a senior developer ... by zeroimpl on Sunday March 27, 2022 @11:43AM (#30821117)
You can't implement an outer join with a cross product.
Re:What's the strangest code you've seen a senior developer ... by goto11 on Sunday March 27, 2022 @03:55PM (#30823480)
You are right, I'm wrong. You can get left, right and inner join by applying constraints to an outer join, but you cant get an outer join from a cross product.