Re:Let's Talk about Joins
by jayknight on Monday January 22, 2024 @07:16PM
(#39097523)
left join requires an `on` clause, which can feel out of place when doing it like this, but makes sense when you consider the parenthesized join to be a relation itself
The parenthesis syntax is also super useful when you want to left join to a group of tables that all need to inner join together:
that way, the b/c/d relation is all or nothing instead of the possibility of get values from b but not c and d.
[ Parent
| on HN ]
There are no comments on this comment yet.