News for hackers. Stuff that matters.
Re:What's the strangest code you've seen a senior developer ... by npteljes on Sunday March 27, 2022 @06:58AM (#30819316)
>When you think about it, all joins are just a left join

Absolutely not. All joins can be related, or explained by using left join as a reference, but there's no such thing as a "default join", or perhaps there is, and it's up to the implementation of the database. Taking the analogy further, all joins are outer joins, just apply some filters, right? Or a left join is just an inner join, and then you include the rest of the left table. It's worthwhile pondering about this, but "all joins are just a left join" is a moot point.

There are no comments on this comment yet.