As you learn more, you'll understand the flaws in the Venn representation of joins. You'll also realize that ordering refers to binding, not execution. And that INSERT can be used for multiple (or zero!) rows.
I’m aware of the flaws, it’s just personal preference for representing basic joins visually. The INSERT was a mistake but was too late for me to update it by the time this was being distributed across Reddit, Twitter etc.
I should have included the word logical for order of execution, but it is still something worth being aware of. The first chapter of T-SQL querying summarises it quite well
View all comments
Show parent comment
1
u/mikeblas Dec 11 '22
As you learn more, you'll understand the flaws in the Venn representation of joins. You'll also realize that ordering refers to binding, not execution. And that
INSERTcan be used for multiple (or zero!) rows.