>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

>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.