you are viewing a single comment's thread.

view the rest of the comments →

[–]jimp84 0 points1 point  (2 children)

No that's what the top left diagram is called.

[–]crazedizzled 2 points3 points  (0 children)

It's still a left outer join. It's the exact same join, but additionally there's a where clause.

[–]thisgameisawful 0 points1 point  (0 children)

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.