here are a few small challenges to test your understanding of joins: https://joins-238123.netlify.com/join-challenges/ …pic.twitter.com/99lV68nZbg
Show this thread
-
-
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Nice. When I explain joins I like to include that rows are joined together whenever the ON clause evals to true, regardless of what crazy logic lives in there
-
that's a good point thanks!
- Show replies
New conversation -
-
-
Your diagrams are awesome! I like to think about sql joins as Venn diagrams when I try to visualise them
-
Why? That's wrong.
- Show replies
New conversation -
-
-
Cross join for test case generation!
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Having used Oracle SQL for 30 years, looking at ANSI SQL makes my head hurt!
-
Me too Still
End of conversation
New conversation -
-
-
Great work as always, but I don't think a join will produce a "bigger" table everytime.
-
yeah "table with more columns" would be more accurate
- Show replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.