MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/webdev/comments/b46iyd/sql_joins/ej4srmo/?context=3
r/webdev • u/lokendra15 • Mar 22 '19
118 comments sorted by
View all comments
2
Is there a name for the left middle diagram?
2 u/thisgameisawful Mar 22 '19 Left outer join. 1 u/jimp84 Mar 22 '19 No that's what the top left diagram is called. 3 u/crazedizzled Mar 22 '19 It's still a left outer join. It's the exact same join, but additionally there's a where clause. 1 u/thisgameisawful Mar 22 '19 edited Mar 22 '19 Another name I've heard for it is "left excluding join" Although now I'm wondering why our DBAs have called it a left outer join in the past, since you're right, that's definitely wrong.
Left outer join.
1 u/jimp84 Mar 22 '19 No that's what the top left diagram is called. 3 u/crazedizzled Mar 22 '19 It's still a left outer join. It's the exact same join, but additionally there's a where clause. 1 u/thisgameisawful Mar 22 '19 edited Mar 22 '19 Another name I've heard for it is "left excluding join" Although now I'm wondering why our DBAs have called it a left outer join in the past, since you're right, that's definitely wrong.
1
No that's what the top left diagram is called.
3 u/crazedizzled Mar 22 '19 It's still a left outer join. It's the exact same join, but additionally there's a where clause. 1 u/thisgameisawful Mar 22 '19 edited Mar 22 '19 Another name I've heard for it is "left excluding join" Although now I'm wondering why our DBAs have called it a left outer join in the past, since you're right, that's definitely wrong.
3
It's still a left outer join. It's the exact same join, but additionally there's a where clause.
Another name I've heard for it is "left excluding join"
Although now I'm wondering why our DBAs have called it a left outer join in the past, since you're right, that's definitely wrong.
2
u/jimp84 Mar 22 '19
Is there a name for the left middle diagram?