Chapter 61 of 1962 min read
Lesson 6.7 β Self-Joins: Joining a Table to Itself
𧬠Biological Scenario: "Find every pair of samples belonging to the same patient" β this requires joining the table to itself, since both "sides" of the relationship live in the same table. π» SQL Code Lab: π€ Expectedβ¦
Sign in to read this
βLesson 6.7 β Self-Joins: Joining a Table to Itselfβ is for subscribers. Start with a free account β it takes a name and an email β then subscribe for $1 a month to open it.
- Python and R courses free in full
- First two chapters of every other course